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 326: from PO_LINE_LOCATIONS_ALL

322: into l_shipment_exist_flag
323: from sys.dual
324: where exists (
325: select 1
326: from PO_LINE_LOCATIONS_ALL
327: where po_header_id = p_po_header_id
328: and po_release_id is NULL );
329:
330: EXCEPTION

Line 1503: From PO_LINE_LOCATIONS_ALL PLL

1499: L_ship_not_responded_flag VARCHAR2(1) := NULL;
1500:
1501: CURSOR l_rel_ship_not_responded_csr IS
1502: select 'Y'
1503: From PO_LINE_LOCATIONS_ALL PLL
1504: Where pll.po_release_id = p_po_release_id
1505: And not exists (
1506: select 1
1507: From PO_ACCEPTANCES PA

Line 1536: From PO_LINE_LOCATIONS_ALL PLL

1532:
1533:
1534: CURSOR l_po_ship_not_responded_csr IS
1535: select 'Y'
1536: From PO_LINE_LOCATIONS_ALL PLL
1537: Where pll.po_header_id = p_po_header_id
1538: And pll.po_release_id is null
1539: And not exists (
1540: select 1