DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on PO_LINES_ALL

Line 130: from po_lines_all pl

126: , pl.item_revision
127: , msi.concatenated_segments
128: , msi.outside_operation_flag
129: , mum.uom_code
130: from po_lines_all pl
131: , mtl_units_of_measure mum
132: , mtl_system_items_kfv msi
133: where pl.item_id = msi.inventory_item_id (+)
134: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 159: from po_lines_all pl

155: , pl.item_revision
156: , msi.concatenated_segments
157: , msi.outside_operation_flag
158: , mum.uom_code
159: from po_lines_all pl
160: , mtl_units_of_measure mum
161: , mtl_system_items_kfv msi
162: , mtl_related_items mri
163: where Nvl(msi.organization_id, p_organization_id) = p_organization_id

Line 199: , po_lines_all pl

195: , msi.outside_operation_flag
196: , mum.uom_code
197: FROM rcv_supply rsup
198: , mtl_units_of_measure mum
199: , po_lines_all pl
200: , mtl_system_items_kfv msi
201: WHERE rsup.po_line_id = pl.po_line_id
202: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
203: AND pl.item_id = msi.inventory_item_id (+)

Line 478: FROM po_line_locations_all poll, po_lines_all po

474: WHERE pol.po_header_id = p_po_header_id
475: AND pol.unit_meas_lookup_code IS NOT NULL
476: AND pol.item_id = p_item_id
477: AND pol.po_line_id IN (SELECT poll.po_line_id
478: FROM po_line_locations_all poll, po_lines_all po
479: WHERE poll.po_header_id = po.po_header_id
480: AND Nvl(poll.approved_flag,'N') = 'Y'
481: AND Nvl(poll.cancel_flag,'N') = 'N'
482: AND Nvl(poll.closed_code,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 505: FROM po_line_locations_all poll, po_lines_all po

501: AND pol.unit_meas_lookup_code IS NOT NULL
502: AND pol.item_id = p_item_id
503: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
504: AND pol.po_line_id IN (SELECT poll.po_line_id
505: FROM po_line_locations_all poll, po_lines_all po
506: WHERE poll.po_header_id = po.po_header_id
507: AND Nvl(poll.approved_flag,'N') = 'Y'
508: AND Nvl(poll.cancel_flag,'N') = 'N'
509: AND Nvl(poll.closed_code,'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 690: from po_lines_all pl

686: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
687: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
688: AND poh.segment1 LIKE (p_doc_number)
689: AND exists ( select 'x'
690: from po_lines_all pl
691: , mtl_system_items_kfv msi
692: where pl.item_id = msi.inventory_item_id (+)
693: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
694: and pl.po_header_id = poh.po_header_id

Line 740: from po_lines_all pl

736: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
737: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
738: AND poh.segment1 LIKE (p_doc_number)
739: AND exists ( select 'x'
740: from po_lines_all pl
741: , mtl_related_items mri
742: , mtl_system_items_kfv msi
743: Where msi.organization_id = p_organization_id
744: and (( mri.related_item_id = msi.inventory_item_id

Line 795: from po_lines_all pol

791: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
792: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
793: AND poh.segment1 LIKE (p_doc_number)
794: AND exists ( select 'x'
795: from po_lines_all pol
796: ,mtl_units_of_measure mum
797: where mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
798: and mum.base_uom_flag(+) = 'Y'
799: and pol.ITEM_ID is null

Line 903: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

899: from mtl_system_items_kfv
900: WHERE organization_id = p_Organization_Id
901: and concatenated_segments like p_concatenated_segments
902: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
903: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
904: where pol.po_header_id = p_poHeaderID
905: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
906: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
907: Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id and

Line 950: from po_lines_all pol

946: msi.inventory_item_flag,
947: 0,
948: msi.inventory_asset_flag,
949: msi.outside_operation_flag
950: from po_lines_all pol
951: ,mtl_related_items mri
952: ,mtl_system_items_kfv msi
953: ,mtl_system_items_kfv msia
954: where msi.organization_id = p_organization_id

Line 1010: from po_lines_all pol

1006: msi.inventory_item_flag,
1007: 0,
1008: msi.inventory_asset_flag,
1009: msi.outside_operation_flag
1010: from po_lines_all pol
1011: , mtl_system_items_kfv msi
1012: where organization_id = p_organization_id
1013: and pol.vendor_product_num like p_concatenated_segments
1014: and pol.item_id = msi.inventory_item_id

Line 1018: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

1014: and pol.item_id = msi.inventory_item_id
1015: and pol.vendor_product_num IS NOT NULL
1016: and pol.po_header_id = p_poHeaderID
1017: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1018: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
1019: where pol.po_header_id = p_poHeaderID
1020: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
1021: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
1022: Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id and

Line 1065: from po_lines_all pol

1061: 'N',
1062: 0,
1063: to_char(NULL),
1064: 'N'
1065: from po_lines_all pol
1066: , mtl_units_of_measure mum
1067: -- Bug 2619063, 2614016
1068: -- Modified to select the base uom for the uom class defined on po.
1069: where mum.uom_class = (SELECT mum2.uom_class

Line 1115: from po_lines_all pol

1111: msi.inventory_item_flag,
1112: 0,
1113: msi.inventory_asset_flag,
1114: msi.outside_operation_flag
1115: from po_lines_all pol
1116: ,mtl_system_items_kfv msi
1117: ,mtl_cross_references mcr
1118: where msi.organization_id = p_organization_id
1119: and ( (mcr.cross_reference_type = p_crossreftype

Line 1132: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

1128: and mcr.inventory_item_id = msi.inventory_item_id
1129: and pol.item_id = msi.inventory_item_id
1130: and pol.po_header_id = p_poHeaderID
1131: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1132: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
1133: where pol.po_header_id = p_poHeaderID
1134: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
1135: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
1136: Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id and

Line 1188: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol WHERE

1184: from mtl_system_items_kfv
1185: WHERE organization_id = p_Organization_Id
1186: and concatenated_segments like p_concatenated_segments
1187: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1188: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol WHERE
1189: pol.po_header_id = p_poHeaderID
1190: and pol.po_line_id = p_poLineID
1191: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')
1192: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )

Line 1236: from po_lines_all pol

1232: msi.inventory_item_flag,
1233: 0,
1234: msi.inventory_asset_flag,
1235: msi.outside_operation_flag
1236: from po_lines_all pol
1237: ,mtl_related_items mri
1238: ,mtl_system_items_kfv msi
1239: ,mtl_system_items_kfv msia
1240: where msi.organization_id = p_organization_id

Line 1297: from po_lines_all pol

1293: msi.inventory_item_flag,
1294: 0,
1295: msi.inventory_asset_flag,
1296: msi.outside_operation_flag
1297: from po_lines_all pol
1298: , mtl_system_items_kfv msi
1299: where organization_id = p_organization_id
1300: and pol.vendor_product_num like p_concatenated_segments
1301: and pol.item_id = msi.inventory_item_id

Line 1305: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

1301: and pol.item_id = msi.inventory_item_id
1302: and pol.vendor_product_num IS NOT NULL
1303: and pol.po_header_id = p_poHeaderID
1304: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1305: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
1306: pl.po_header_id = p_poHeaderID
1307: and pl.po_line_id = p_poLineID
1308: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')
1309: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )

Line 1353: from po_lines_all pol

1349: 'N',
1350: 0,
1351: to_char(NULL),
1352: 'N'
1353: from po_lines_all pol
1354: , mtl_units_of_measure mum
1355: -- Bug 2619063, 2614016
1356: -- Modified to select the base uom for the uom class defined on po.
1357: where mum.uom_class = (SELECT mum2.uom_class

Line 1404: from po_lines_all pol

1400: msi.inventory_item_flag,
1401: 0,
1402: msi.inventory_asset_flag,
1403: msi.outside_operation_flag
1404: from po_lines_all pol
1405: ,mtl_system_items_kfv msi
1406: ,mtl_cross_references mcr
1407: where msi.organization_id = p_organization_id
1408: and ( (mcr.cross_reference_type = p_crossreftype

Line 1421: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

1417: and mcr.inventory_item_id = msi.inventory_item_id
1418: and pol.item_id = msi.inventory_item_id
1419: and pol.po_header_id = p_poHeaderID
1420: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1421: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
1422: pl.po_header_id = p_poHeaderID
1423: and pl.po_line_id = p_poLineID
1424: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')
1425: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )

Line 1478: ( SELECT pol.item_id FROM po_lines_all pol WHERE pol.po_header_id =

1474: WHERE organization_id = p_Organization_Id
1475: and concatenated_segments like p_concatenated_segments
1476: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1477: and inventory_item_id IN
1478: ( SELECT pol.item_id FROM po_lines_all pol WHERE pol.po_header_id =
1479: p_poHeaderID
1480: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')
1481: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and pll.po_header_id =
1482: p_poHeaderID and pll.po_line_id = pol.po_line_id

Line 1524: from po_lines_all pol

1520: msi.inventory_item_flag,
1521: 0,
1522: msi.inventory_asset_flag,
1523: msi.outside_operation_flag
1524: from po_lines_all pol
1525: ,mtl_related_items mri
1526: ,mtl_system_items_kfv msi
1527: ,mtl_system_items_kfv msia
1528: where msi.organization_id = p_organization_id

Line 1584: from po_lines_all pol

1580: msi.inventory_item_flag,
1581: 0,
1582: msi.inventory_asset_flag,
1583: msi.outside_operation_flag
1584: from po_lines_all pol
1585: , mtl_system_items_kfv msi
1586: where organization_id = p_organization_id
1587: and pol.vendor_product_num like p_concatenated_segments
1588: and pol.item_id = msi.inventory_item_id

Line 1593: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =

1589: and pol.vendor_product_num IS NOT NULL
1590: and pol.po_header_id = p_poHeaderID
1591: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1592: and inventory_item_id IN
1593: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
1594: p_poHeaderID
1595: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')
1596: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and pll.po_header_id =
1597: p_poHeaderID and pll.po_line_id = pl.po_line_id

Line 1639: from po_lines_all pol

1635: 'N',
1636: 0,
1637: to_char(NULL),
1638: 'N'
1639: from po_lines_all pol
1640: , mtl_units_of_measure mum
1641: -- Bug 2619063, 2614016
1642: -- Modified to select the base uom for the uom class defined on po.
1643: where mum.uom_class = (SELECT mum2.uom_class

Line 1690: from po_lines_all pol

1686: msi.inventory_item_flag,
1687: 0,
1688: msi.inventory_asset_flag,
1689: msi.outside_operation_flag
1690: from po_lines_all pol
1691: ,mtl_system_items_kfv msi
1692: ,mtl_cross_references mcr
1693: where msi.organization_id = p_organization_id
1694: and ( (mcr.cross_reference_type = p_crossreftype

Line 1708: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =

1704: and pol.item_id = msi.inventory_item_id
1705: and pol.po_header_id = p_poHeaderID
1706: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1707: and msi.inventory_item_id IN
1708: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
1709: p_poHeaderID
1710: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')
1711: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
1712: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 1770: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

1766: from mtl_system_items_kfv
1767: WHERE organization_id = p_Organization_Id
1768: and concatenated_segments like p_concatenated_segments
1769: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1770: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
1771: where pol.po_header_id = p_poHeaderID
1772: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
1773: not in ('CLOSED','FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
1774: Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id and

Line 1810: from po_lines_all pol

1806: msi.inventory_item_flag,
1807: 0,
1808: msi.inventory_asset_flag,
1809: msi.outside_operation_flag
1810: from po_lines_all pol
1811: ,mtl_related_items mri
1812: ,mtl_system_items_kfv msi
1813: ,mtl_system_items_kfv msia
1814: where msi.organization_id = p_organization_id

Line 1863: from po_lines_all pol

1859: msi.inventory_item_flag,
1860: 0,
1861: msi.inventory_asset_flag,
1862: msi.outside_operation_flag
1863: from po_lines_all pol
1864: , mtl_system_items_kfv msi
1865: where organization_id = p_organization_id
1866: and pol.vendor_product_num like p_concatenated_segments
1867: and pol.item_id = msi.inventory_item_id

Line 1871: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

1867: and pol.item_id = msi.inventory_item_id
1868: and pol.vendor_product_num IS NOT NULL
1869: and pol.po_header_id = p_poHeaderID
1870: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1871: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
1872: where pol.po_header_id = p_poHeaderID
1873: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
1874: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
1875: pll.po_header_id = p_poHeaderID

Line 1911: from po_lines_all pol

1907: 'N',
1908: 0,
1909: to_char(NULL),
1910: 'N'
1911: from po_lines_all pol
1912: , mtl_units_of_measure mum
1913: -- Bug 2619063, 2614016
1914: -- Modified to select the base uom for the uom class defined on po.
1915: where mum.uom_class = (SELECT mum2.uom_class

Line 1954: from po_lines_all pol

1950: msi.inventory_item_flag,
1951: 0,
1952: msi.inventory_asset_flag,
1953: msi.outside_operation_flag
1954: from po_lines_all pol
1955: ,mtl_system_items_kfv msi
1956: ,mtl_cross_references mcr
1957: where msi.organization_id = p_organization_id
1958: and ( (mcr.cross_reference_type = p_crossreftype

Line 1971: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

1967: and mcr.inventory_item_id = msi.inventory_item_id
1968: and pol.item_id = msi.inventory_item_id
1969: and pol.po_header_id = p_poHeaderID
1970: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1971: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
1972: where pol.po_header_id = p_poHeaderID
1973: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')
1974: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING') and
1975: pll.po_header_id = p_poHeaderID

Line 2019: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

2015: from mtl_system_items_kfv
2016: WHERE organization_id = p_Organization_Id
2017: and concatenated_segments like p_concatenated_segments
2018: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2019: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
2020: pl.po_header_id = p_poHeaderID
2021: and pl.po_line_id = p_poLineID
2022: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,
2023: 'OPEN')

Line 2060: from po_lines_all pol

2056: msi.inventory_item_flag,
2057: 0,
2058: msi.inventory_asset_flag,
2059: msi.outside_operation_flag
2060: from po_lines_all pol
2061: ,mtl_related_items mri
2062: ,mtl_system_items_kfv msi
2063: ,mtl_system_items_kfv msia
2064: where msi.organization_id = p_organization_id

Line 2112: from po_lines_all pol

2108: msi.inventory_item_flag,
2109: 0,
2110: msi.inventory_asset_flag,
2111: msi.outside_operation_flag
2112: from po_lines_all pol
2113: ,mtl_system_items_kfv msi
2114: where organization_id = p_organization_id
2115: and pol.vendor_product_num like p_concatenated_segments
2116: and pol.item_id = msi.inventory_item_id

Line 2120: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

2116: and pol.item_id = msi.inventory_item_id
2117: and pol.vendor_product_num IS NOT NULL
2118: and pol.po_header_id = p_poHeaderID
2119: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2120: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
2121: pl.po_header_id = p_poHeaderID
2122: and pl.po_line_id = p_poLineID
2123: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,
2124: 'OPEN')

Line 2161: from po_lines_all pol

2157: 'N',
2158: 0,
2159: to_char(NULL),
2160: 'N'
2161: from po_lines_all pol
2162: , mtl_units_of_measure mum
2163: -- Bug 2619063, 2614016
2164: -- Modified to select the base uom for the uom class defined on po.
2165: where mum.uom_class = (SELECT mum2.uom_class

Line 2204: from po_lines_all pol

2200: msi.inventory_item_flag,
2201: 0,
2202: msi.inventory_asset_flag,
2203: msi.outside_operation_flag
2204: from po_lines_all pol
2205: ,mtl_system_items_kfv msi
2206: ,mtl_cross_references mcr
2207: where msi.organization_id = p_organization_id
2208: and ( (mcr.cross_reference_type = p_crossreftype

Line 2221: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

2217: and mcr.inventory_item_id = msi.inventory_item_id
2218: and pol.item_id = msi.inventory_item_id
2219: and pol.po_header_id = p_poHeaderID
2220: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2221: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
2222: pl.po_header_id = p_poHeaderID
2223: and pl.po_line_id = p_poLineID
2224: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,
2225: 'OPEN')

Line 2271: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID

2267: WHERE organization_id = p_Organization_Id
2268: and concatenated_segments like p_concatenated_segments
2269: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2270: and inventory_item_id IN
2271: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID
2272: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')
2273: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
2274: and pll.po_header_id = p_poHeaderID
2275: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2309: from po_lines_all pol

2305: msi.inventory_item_flag,
2306: 0,
2307: msi.inventory_asset_flag,
2308: msi.outside_operation_flag
2309: from po_lines_all pol
2310: ,mtl_related_items mri
2311: ,mtl_system_items_kfv msi
2312: ,mtl_system_items_kfv msia
2313: where msi.organization_id = p_organization_id

Line 2361: from po_lines_all pol

2357: msi.inventory_item_flag,
2358: 0,
2359: msi.inventory_asset_flag,
2360: msi.outside_operation_flag
2361: from po_lines_all pol
2362: , mtl_system_items_kfv msi
2363: where organization_id = p_organization_id
2364: and pol.vendor_product_num like p_concatenated_segments
2365: and pol.item_id = msi.inventory_item_id

Line 2370: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =

2366: and pol.vendor_product_num IS NOT NULL
2367: and pol.po_header_id = p_poHeaderID
2368: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2369: and inventory_item_id IN
2370: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
2371: p_poHeaderID
2372: and exists (select 1 from po_line_locations_all pll where
2373: NVL(pll.closed_code,'OPEN')
2374: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')

Line 2410: from po_lines_all pol

2406: 'N',
2407: 0,
2408: to_char(NULL),
2409: 'N'
2410: from po_lines_all pol
2411: , mtl_units_of_measure mum
2412: -- Bug 2619063, 2614016
2413: -- Modified to select the base uom for the uom class defined on po.
2414: where mum.uom_class = (SELECT mum2.uom_class

Line 2453: from po_lines_all pol

2449: msi.inventory_item_flag,
2450: 0,
2451: msi.inventory_asset_flag,
2452: msi.outside_operation_flag
2453: from po_lines_all pol
2454: ,mtl_system_items_kfv msi
2455: ,mtl_cross_references mcr
2456: where msi.organization_id = p_organization_id
2457: and ( (mcr.cross_reference_type = p_crossreftype

Line 2471: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID

2467: and pol.item_id = msi.inventory_item_id
2468: and pol.po_header_id = p_poHeaderID
2469: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2470: and msi.inventory_item_id IN
2471: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID
2472: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')
2473: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
2474: and pll.po_header_id = p_poHeaderID
2475: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2567: from po_lines_all pol

2563: msi.inventory_item_flag,
2564: 0,
2565: msi.inventory_asset_flag,
2566: msi.outside_operation_flag
2567: from po_lines_all pol
2568: ,mtl_system_items_kfv msi
2569: , rcv_shipment_lines rsl
2570: where organization_id = p_Organization_Id
2571: and pol.vendor_product_num like p_concatenated_segments

Line 2577: FROM po_lines_all pl

2573: and pol.vendor_product_num IS NOT NULL
2574: and pol.po_header_id = Nvl(p_poheaderid,pol.po_header_id)
2575: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2576: and inventory_item_id IN (SELECT pl.item_id
2577: FROM po_lines_all pl
2578: WHERE pl.po_header_id = rsl.po_header_id
2579: and pl.po_line_id = rsl.po_line_id
2580: and exists (select 1 from
2581: po_line_locations_all pll

Line 2624: from po_lines_all pol

2620: 'N',
2621: 0,
2622: to_char(NULL),
2623: 'N'
2624: from po_lines_all pol
2625: , mtl_units_of_measure mum
2626: , rcv_shipment_lines rsl
2627: -- Bug 2619063, 2614016
2628: -- Modified to select the base uom for the uom class defined on po.

Line 2956: from po_lines_all pol

2952: msi.inventory_item_flag,
2953: 0,
2954: msi.inventory_asset_flag,
2955: msi.outside_operation_flag
2956: from po_lines_all pol
2957: ,mtl_related_items mri
2958: ,mtl_system_items_kfv msi
2959: ,mtl_system_items_kfv msia
2960: where msi.organization_id = p_organization_id

Line 3008: from po_lines_all pol

3004: msi.inventory_item_flag,
3005: 0,
3006: msi.inventory_asset_flag,
3007: msi.outside_operation_flag
3008: from po_lines_all pol
3009: ,mtl_system_items_kfv msi
3010: where organization_id = p_organization_id
3011: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3012: and pol.vendor_product_num like p_concatenated_segments

Line 3090: from po_lines_all pol

3086: 'N',
3087: 0,
3088: to_char(NULL),
3089: 'N'
3090: from po_lines_all pol
3091: ,mtl_units_of_measure mum
3092: -- Bug 2619063, 2614016
3093: -- Modified to select the base uom for the uom class defined on po.
3094: where mum.uom_class = (SELECT mum2.uom_class