DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 861: mtl_system_items_kfv msi,

857: l_job_name, --
858: l_job_long_description, --
859: l_from_org_id */ --
860: from po_requisition_lines_all rl, --
861: mtl_system_items_kfv msi,
862: per_jobs_vl PJ,
863: PO_SESSION_GT psg --
864: where requisition_line_id = psg.key --
865: and rl.item_id = msi.inventory_item_id(+)

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

2023: pl.contract_type,
2024: pl.cost_constraint,
2025: pl.clm_idc_type
2026:
2027: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
2028: financials_system_parameters fsp --
2029: where po_header_id=p_po_header_id and
2030: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
2031: --bug #2716412: made pl/msi join an outer join

Line 2752: mtl_system_items_kfv msi,

2748: rl.COST_CONSTRAINT,
2749: decode(rl.CONTRACT_TYPE, null, null, ''IDC_NA''),
2750: rl.UDA_TEMPLATE_ID --
2751: from po_requisition_lines_all rl, --
2752: mtl_system_items_kfv msi,
2753: per_jobs_vl PJ,
2754: PO_SESSION_GT psg --
2755: where requisition_line_id = psg.key --
2756: and rl.item_id = msi.inventory_item_id(+)