APPS.PO_ACKNOWLEDGE_PO_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 31: From PO_LINE_LOCATIONS_ALL PLL

27: l_ship_not_acked_flag VARCHAR2(1) := NULL;
28:
29: CURSOR l_rel_ship_not_acked_csr IS
30: select 'Y'
31: From PO_LINE_LOCATIONS_ALL PLL
32: Where pll.po_release_id = p_po_release_id
33: And not exists (
34: select 1
35: From PO_ACCEPTANCES PA

Line 48: From PO_LINE_LOCATIONS_ALL PLL

44: pll.consigned_flag = 'Y'));
45:
46: CURSOR l_po_ship_not_acked_csr IS
47: select 'Y'
48: From PO_LINE_LOCATIONS_ALL PLL
49: Where pll.po_header_id = p_po_header_id
50: And pll.po_release_id is null
51: And not exists (
52: select 1

Line 339: from PO_LINE_LOCATIONS_ALL

335: into l_shipment_exist_flag
336: from sys.dual
337: where exists (
338: select 1
339: from PO_LINE_LOCATIONS_ALL
340: where po_header_id = p_po_header_id
341: and po_release_id is NULL );
342:
343: EXCEPTION

Line 1516: From PO_LINE_LOCATIONS_ALL PLL

1512: L_ship_not_responded_flag VARCHAR2(1) := NULL;
1513:
1514: CURSOR l_rel_ship_not_responded_csr IS
1515: select 'Y'
1516: From PO_LINE_LOCATIONS_ALL PLL
1517: Where pll.po_release_id = p_po_release_id
1518: And not exists (
1519: select 1
1520: From PO_ACCEPTANCES PA

Line 1549: From PO_LINE_LOCATIONS_ALL PLL

1545:
1546:
1547: CURSOR l_po_ship_not_responded_csr IS
1548: select 'Y'
1549: From PO_LINE_LOCATIONS_ALL PLL
1550: Where pll.po_header_id = p_po_header_id
1551: And pll.po_release_id is null
1552: And not exists (
1553: select 1