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 1739: FROM po_line_locations_all PLL

1735: AND PLLD.change_accepted_flag IS NULL
1736: AND PLLD.delete_flag = 'Y'
1737: AND NOT EXISTS
1738: ( SELECT 1
1739: FROM po_line_locations_all PLL
1740: WHERE PLLD.line_location_id = PLL.line_location_id);
1741:
1742: d_position := 20;
1743:

Line 1918: FROM po_line_locations_all PLL

1914: AND PLLD.change_accepted_flag IS NULL
1915: AND NVL(PLLD.delete_flag, 'N') <> 'Y'
1916: AND EXISTS
1917: ( SELECT 1
1918: FROM po_line_locations_all PLL
1919: WHERE PLLD.line_location_id = PLL.line_location_id
1920: AND DECODE (PLLD.ship_to_organization_id,
1921: PLL.ship_to_organization_id, 'Y', 'N') = 'Y'
1922: AND DECODE (PLLD.ship_to_location_id,

Line 3137: FROM po_line_locations_all PLLA,

3133: AND PLDA.po_line_id = PLLDA.po_line_id
3134: AND PLDA.draft_id = PLLDA.draft_id )
3135: AND NOT EXISTS
3136: ( SELECT NULL
3137: FROM po_line_locations_all PLLA,
3138: po_lines_draft_all PLDA
3139: WHERE PLLA.line_location_id = PPDD.entity_id
3140: AND PLDA.po_line_id = PLLA.po_line_id
3141: AND PLDA.draft_id = PPDD.draft_id)));

Line 3262: FROM po_line_locations_all PLLD

3258: AND PLLD.po_line_id = p_line_id_list(i)
3259: AND PLLD.line_location_id = PPDD.entity_id
3260: UNION ALL
3261: SELECT 1
3262: FROM po_line_locations_all PLLD
3263: WHERE PLLD.po_line_id = p_line_id_list(i)
3264: AND PLLD.line_location_id = PPDD.entity_id);
3265:
3266: IF (PO_LOG.d_proc) THEN