eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_MOBILE_RECEIPT dependencies on PO_LINE_LOCATIONS_ALL

Line 138: FROM po_line_locations_all poll

134: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
135: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
136: and pl.po_header_id = p_po_header_id
137: and exists (SELECT 'Valid PO Shipments'
138: FROM po_line_locations_all poll
139: WHERE poll.po_header_id = pl.po_header_id
140: AND poll.po_line_id = pl.po_line_id
141: AND Nvl(poll.approved_flag,'N') = 'Y'
142: AND Nvl(poll.cancel_flag,'N') = 'N'

Line 167: FROM po_line_locations_all poll

163: where Nvl(msi.organization_id, p_organization_id) = p_organization_id
164: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
165: and pl.po_header_id = p_po_header_id
166: and exists (SELECT 'Valid PO Shipments'
167: FROM po_line_locations_all poll
168: WHERE poll.po_header_id = pl.po_header_id
169: AND poll.po_line_id = pl.po_line_id
170: AND Nvl(poll.approved_flag,'N') = 'Y'
171: AND Nvl(poll.cancel_flag,'N') = 'N'

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 675: FROM po_line_locations_all poll

671: AND nvl(flv.start_date_active, sysdate)<=sysdate
672: AND nvl(flv.end_date_active,sysdate)>=sysdate
673: AND flv.enabled_flag = 'Y'
674: AND exists (SELECT 'Valid PO Shipments'
675: FROM po_line_locations_all poll
676: WHERE poh.po_header_id = poll.po_header_id
677: AND Nvl(poll.approved_flag,'N') = 'Y'
678: AND Nvl(poll.cancel_flag,'N') = 'N'
679: -- AND poll.closed_code = 'OPEN' -- Bug 2859335

Line 725: FROM po_line_locations_all poll

721: AND nvl(flv.start_date_active, sysdate)<=sysdate
722: AND nvl(flv.end_date_active,sysdate)>=sysdate
723: AND flv.enabled_flag = 'Y'
724: AND exists (SELECT 'Valid PO Shipments'
725: FROM po_line_locations_all poll
726: WHERE poh.po_header_id = poll.po_header_id
727: AND Nvl(poll.approved_flag,'N') = 'Y'
728: AND Nvl(poll.cancel_flag,'N') = 'N'
729: -- AND poll.closed_code = 'OPEN' -- Bug 2859355

Line 780: FROM po_line_locations_all poll

776: AND nvl(flv.start_date_active, sysdate)<=sysdate
777: AND nvl(flv.end_date_active,sysdate)>=sysdate
778: AND flv.enabled_flag = 'Y'
779: AND exists (SELECT 'Valid PO Shipments'
780: FROM po_line_locations_all poll
781: WHERE poh.po_header_id = poll.po_header_id
782: AND Nvl(poll.approved_flag,'N') = 'Y'
783: AND Nvl(poll.cancel_flag,'N') = 'N'
784: AND receiving_routing_id = 3 --- Direct only supported by OPM

Line 905: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
908: pll.po_header_id = p_poHeaderID
909: and pll.po_release_id = p_poReleaseID

Line 964: and exists (select 1 from po_line_locations_all pll

960: and pol.item_id = mri.inventory_item_id) or
961: ( mri.inventory_item_id = msi.inventory_item_id
962: and pol.item_id = mri.related_item_id
963: and mri.reciprocal_flag = 'Y'))
964: and exists (select 1 from po_line_locations_all pll
965: where NVL(pll.closed_code,'OPEN')
966: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
967: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
968: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 1020: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
1023: pll.po_header_id = p_poHeaderID
1024: and pll.po_release_id = p_poReleaseID

Line 1134: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
1137: pll.po_header_id = p_poHeaderID
1138: and pll.po_release_id = p_poReleaseID

Line 1191: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')

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' )
1193: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1194: and pll.po_header_id = p_poHeaderID
1195: and pll.po_line_id = p_poLineID

Line 1251: and exists (select 1 from po_line_locations_all pll

1247: ( mri.inventory_item_id = msi.inventory_item_id
1248: and pol.item_id = mri.related_item_id
1249: and mri.reciprocal_flag = 'Y'))
1250: and pol.po_line_id = p_poLineID
1251: and exists (select 1 from po_line_locations_all pll
1252: where NVL(pll.closed_code,'OPEN') not in
1253: ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
1254: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1255: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 1308: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')

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' )
1310: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1311: and pll.po_header_id = p_poHeaderID
1312: and pll.po_line_id = p_poLineID

Line 1424: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code, 'OPEN')

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' )
1426: and Nvl(pll.ship_to_organization_id,p_organization_id) = p_organization_id
1427: and pll.po_header_id = p_poHeaderID
1428: and pll.po_line_id = p_poLineID

Line 1480: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')

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
1483: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1484: AND Nvl(pll.cancel_flag,'N') = 'N'

Line 1538: and exists (select 1 from po_line_locations_all pll

1534: and pol.item_id = mri.inventory_item_id) or
1535: ( mri.inventory_item_id = msi.inventory_item_id
1536: and pol.item_id = mri.related_item_id
1537: and mri.reciprocal_flag = 'Y'))
1538: and exists (select 1 from po_line_locations_all pll
1539: where NVL(pll.closed_code,'OPEN') not in ('CLOSED', 'FINALLY CLOSED',
1540: 'CLOSED FOR RECEIVING')
1541: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1542: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 1595: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')

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
1598: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1599: AND Nvl(pll.cancel_flag,'N') = 'N'

Line 1710: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')

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
1713: and pll.po_header_id = p_poHeaderID and pll.po_line_id = pl.po_line_id
1714: AND Nvl(pll.cancel_flag,'N') = 'N'

Line 1772: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
1775: pll.po_header_id = p_poHeaderID
1776: and pll.po_release_id = p_poReleaseID

Line 1824: and exists (select 1 from po_line_locations_all pll

1820: and pol.item_id = mri.inventory_item_id) or
1821: ( mri.inventory_item_id = msi.inventory_item_id
1822: and pol.item_id = mri.related_item_id
1823: and mri.reciprocal_flag = 'Y'))
1824: and exists (select 1 from po_line_locations_all pll
1825: where NVL(pll.closed_code,'OPEN')
1826: not in ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
1827: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1828: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 1873: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
1876: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1877: and pll.po_release_id = p_poReleaseID

Line 1973: and exists (select 1 from po_line_locations_all pll WHERE NVL(pll.closed_code,'OPEN')

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
1976: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id
1977: and pll.po_release_id = p_poReleaseID

Line 2022: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,

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')
2024: not in ('CLOSED','FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )
2025: and pll.po_header_id = p_poHeaderID
2026: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2075: and exists (select 1 from po_line_locations_all pll

2071: ( mri.inventory_item_id = msi.inventory_item_id
2072: and pol.item_id = mri.related_item_id
2073: and mri.reciprocal_flag = 'Y'))
2074: and pol.po_line_id = p_poLineID
2075: and exists (select 1 from po_line_locations_all pll
2076: where NVL(pll.closed_code,'OPEN') not in
2077: ('CLOSED', 'FINALLY CLOSED', 'CLOSED FOR RECEIVING')
2078: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'
2079: and pll.po_header_id = pol.po_header_id

Line 2123: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,

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')
2125: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )
2126: and pll.po_header_id = p_poHeaderID
2127: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2224: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,

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')
2226: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )
2227: and pll.po_header_id = p_poHeaderID
2228: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2272: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')

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
2276: and pll.po_line_id = pl.po_line_id

Line 2323: and exists (select 1 from po_line_locations_all pll

2319: and pol.item_id = mri.inventory_item_id) or
2320: ( mri.inventory_item_id = msi.inventory_item_id
2321: and pol.item_id = mri.related_item_id
2322: and mri.reciprocal_flag = 'Y'))
2323: and exists (select 1 from po_line_locations_all pll
2324: where NVL(pll.closed_code,'OPEN') not in ('CLOSED','FINALLY CLOSED',
2325: 'CLOSED FOR RECEIVING')
2326: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'
2327: and pll.po_header_id = pol.po_header_id

Line 2372: and exists (select 1 from po_line_locations_all pll where

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')
2375: and pll.po_header_id = p_poHeaderID
2376: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2472: and exists (select 1 from po_line_locations_all pll where NVL(pll.closed_code,'OPEN')

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
2476: and pll.po_line_id = pl.po_line_id

Line 2581: po_line_locations_all pll

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
2582: where NVL(pll.closed_code,'OPEN')
2583: not in ('CLOSED', 'FINALLY CLOSED' , 'CLOSED FOR RECEIVING' )
2584: and pll.po_header_id = rsl.po_header_id
2585: and Nvl(pll.ship_to_organization_id, p_organization_id) = p_organization_id

Line 2969: and exists ( select 1 from po_line_locations_all pll

2965: and pol.item_id = mri.inventory_item_id) or
2966: (mri.inventory_item_id = msi.inventory_item_id
2967: and pol.item_id = mri.related_item_id
2968: and mri.reciprocal_flag = 'Y'))
2969: and exists ( select 1 from po_line_locations_all pll
2970: where
2971: -- pll.closed_code = 'OPEN' -- Bug 2859355
2972: Nvl(pll.closed_code,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED','CLOSED FOR RECEIVING')
2973: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'