本帖最后由 ForrestAgain 于 2014-8-12 08:59 编辑
已经搞定了。
这个是SPO的。
select decode(rcv1.organization_id, 11, 'AAA') AS OU,
PHA.Type_Lookup_Code,
PHA.SEGMENT1 AS PO_Num,
rcv1.po_release,
PRA.Release_Num,
pra.release_num,
pla.line_num,
msi.segment1,
msi.description,
plla.quantity,
plla.price_override,
plla.quantity_received,
plla.quantity_accepted,
plla.quantity_rejected,
plla.quantity_billed,
rcv1.supplier_site_id,
rcv1.vendor_name,
pvsa.VENDOR_SITE_CODE,
rcv1.transaction_id,
rcv1.transaction_type,
rcv1.transaction_date,
rcv1.transact_qty,
rcv1.transact_uom,
decode(cicd.cost_type_id, 1, 'Froze') AS Cost_Type,
cicd.item_cost,
rcv1.subinventory,
rcv1.currency_code,
rcv1.currency_conversion_type,
rcv1.currency_conversion_date,
rcv1.currency_conversion_rate
from RCV_VRC_TXS_VENDINT_V rcv1,
Po_Headers_AllPHA,
Po_Releases_All PRA,
Po_Line_Locations_all PLLA,
Po_Lines_All
pla,
mtl_system_itemsmsi,
Po_Vendor_Sites_All PVSA, --
cst_item_cost_details cicd
where rcv1.organization_id = 11
and rcv1.transaction_type = 'DELIVER'
and rcv1.organization_id = pha.org_id
and pha.org_id = pra.org_id
and pra.org_id = plla.org_id
and plla.org_id = pla.org_id
and pla.org_id = msi.organization_id
and msi.organization_id = cicd.organization_id
and rcv1.po_header_id = pha.po_header_id
and pha.po_header_id = pra.po_header_id
and pha.po_header_id = plla.po_header_id
and pra.po_release_id = plla.po_release_id
and plla.po_release_id = rcv1.po_release_id
and plla.po_header_id = pla.po_header_id
and plla.po_line_id = pla.po_line_id
and pla.po_line_id = rcv1.po_line_id
and pla.item_id = msi.inventory_item_id
and msi.inventory_item_id = cicd.inventory_item_id
and cicd.cost_type_id = 1
and rcv1.vendor_id = pha.vendor_id
and pha.vendor_site_id = pvsa.VENDOR_SITE_ID
and pha.segment1 = 1234 -- 测试PO 号码 复制代码
|
