APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 819: po_line_locations_all LL,

815: AND change_accepted_flag IS NULL
816: UNION
817: SELECT NVL(LLD.po_line_id, LL.po_line_id)
818: FROM po_line_locations_draft_all LLD,
819: po_line_locations_all LL,
820: po_price_diff_draft PDD
821: WHERE PDD.draft_id = l_draft_id
822: AND entity_type = 'PRICE BREAK'
823: AND PDD.change_accepted_flag IS NULL

Line 1765: FROM po_line_locations_all PLL

1761: AND PLLD.change_accepted_flag IS NULL
1762: AND PLLD.delete_flag = 'Y'
1763: AND NOT EXISTS
1764: ( SELECT 1
1765: FROM po_line_locations_all PLL
1766: WHERE PLLD.line_location_id = PLL.line_location_id);
1767:
1768: d_position := 20;
1769:

Line 1944: FROM po_line_locations_all PLL

1940: AND PLLD.change_accepted_flag IS NULL
1941: AND NVL(PLLD.delete_flag, 'N') <> 'Y'
1942: AND EXISTS
1943: ( SELECT 1
1944: FROM po_line_locations_all PLL
1945: WHERE PLLD.line_location_id = PLL.line_location_id
1946: AND DECODE (PLLD.ship_to_organization_id,
1947: PLL.ship_to_organization_id, 'Y', 'N') = 'Y'
1948: AND DECODE (PLLD.ship_to_location_id,

Line 3163: FROM po_line_locations_all PLLA,

3159: AND PLDA.po_line_id = PLLDA.po_line_id
3160: AND PLDA.draft_id = PLLDA.draft_id )
3161: AND NOT EXISTS
3162: ( SELECT NULL
3163: FROM po_line_locations_all PLLA,
3164: po_lines_draft_all PLDA
3165: WHERE PLLA.line_location_id = PPDD.entity_id
3166: AND PLDA.po_line_id = PLLA.po_line_id
3167: AND PLDA.draft_id = PPDD.draft_id)));

Line 3288: FROM po_line_locations_all PLLD

3284: AND PLLD.po_line_id = p_line_id_list(i)
3285: AND PLLD.line_location_id = PPDD.entity_id
3286: UNION ALL
3287: SELECT 1
3288: FROM po_line_locations_all PLLD
3289: WHERE PLLD.po_line_id = p_line_id_list(i)
3290: AND PLLD.line_location_id = PPDD.entity_id);
3291:
3292: IF (PO_LOG.d_proc) THEN