DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 562: mtl_system_items_kfv msi,

558: l_job_name, --
559: l_job_long_description, --
560: l_from_org_id */ --
561: from po_requisition_lines_all rl, --
562: mtl_system_items_kfv msi,
563: per_jobs_vl PJ,
564: PO_SESSION_GT psg --
565: where requisition_line_id = psg.key --
566: and rl.item_id = msi.inventory_item_id(+)

Line 1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,

1452: , 'RATE' , PL.committed_amount
1453: , NULL),
1454: PL.purchase_basis, --
1455: pl.ip_category_id --
1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
1457: financials_system_parameters fsp --
1458: where po_header_id=p_po_header_id and
1459: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
1460: --bug #2716412: made pl/msi join an outer join