DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS4_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1442: mtl_system_items msi

1438: prl.unit_meas_lookup_code,
1439: decode(prl.item_id, null, null, prl.need_by_date + nvl(msi.postprocessing_lead_time,0)),
1440: DECODE(PO_CLM_INTG_GRP.IS_CLM_DOCUMENT('REQUISITION',prl.Requisition_header_id),'Y','Y','N',NULL,NULL) --
1441: FROM po_requisition_lines_all prl, --
1442: mtl_system_items msi
1443: WHERE prl.requisition_line_id =
1444: new_req_line_id_rslt_tbl(l_update_mtl_supply_index)
1445: AND prl.destination_organization_id = msi.organization_id(+)
1446: AND prl.item_id = msi.inventory_item_id(+)