[Home] [Help]
272: PO_LINE_LOCATIONS POLL,
273: PO_LINES POL,
274: PO_RELEASES POR,
275: MTL_SYSTEM_ITEMS MSI,
276: MTL_UNITS_OF_MEASURE mum,
277: PO_DISTRIBUTIONS POD
278: WHERE
279: POD.PO_DISTRIBUTION_ID = v_po_distribution_id
280: AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID
730: PO_LINE_LOCATIONS POLL,
731: PO_LINES POL,
732: PO_RELEASES POR,
733: MTL_SYSTEM_ITEMS MSI,
734: MTL_UNITS_OF_MEASURE mum,
735: PO_DISTRIBUTIONS POD
736: WHERE
737: POD.PO_DISTRIBUTION_ID = v_po_distribution_id
738: AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID
1267: PO_REQUISITION_HEADERS PORH,
1268: PO_REQUISITION_LINES PORL,
1269: MTL_SYSTEM_ITEMS MSI,
1270: MTL_SYSTEM_ITEMS MSI1,
1271: MTL_UNITS_OF_MEASURE MUM
1272: WHERE
1273: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'
1274: AND RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID(+)
1275: AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID(+)
1751: FROM
1752: OE_ORDER_LINES_all OEL,
1753: OE_ORDER_HEADERS_all OEH,
1754: MTL_SYSTEM_ITEMS MSI,
1755: MTL_UNITS_OF_MEASURE MUM
1756: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
1757: AND OEL.HEADER_ID = OEH.HEADER_ID
1758: AND OEL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
1759: AND OEL.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID
2188: PO_LINE_LOCATIONS POLL,
2189: PO_LINES POL,
2190: PO_RELEASES POR,
2191: MTL_SYSTEM_ITEMS MSI,
2192: MTL_UNITS_OF_MEASURE MUM,
2193: PO_DISTRIBUTIONS POD
2194: WHERE
2195: POD.PO_DISTRIBUTION_ID = v_po_distribution_id
2196: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2350: PO_REQUISITION_HEADERS PORH,
2351: PO_REQUISITION_LINES PORL,
2352: MTL_SYSTEM_ITEMS MSI,
2353: MTL_SYSTEM_ITEMS MSI1,
2354: MTL_UNITS_OF_MEASURE MUM
2355: WHERE
2356: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'
2357: AND RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID(+)
2358: AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID(+)