APPS.PO_ASL_API_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 2677: po_line_locations_all poll,

2673: AND ( poh.status_lookup_code = 'A' )
2674: AND ( poh.approval_required_flag = 'Y' )
2675: AND ( EXISTS (SELECT 'x'
2676: FROM po_quotation_approvals poqa,
2677: po_line_locations_all poll,
2678: po_lines_all pol
2679: WHERE poqa.approval_type IS NOT NULL
2680: AND poqa.line_location_id =
2681: poll.line_location_id

Line 2688: FROM po_line_locations_all poll,

2684: AND pol.po_header_id = poh.po_header_id
2685: AND Trunc(SYSDATE) <=
2686: Nvl(poh.end_date, SYSDATE + 1))
2687: OR NOT EXISTS (SELECT 'no shipments exists'
2688: FROM po_line_locations_all poll,
2689: po_lines_all pol
2690: WHERE poll.po_line_id = pol.po_line_id
2691: AND pol.item_id = l_item_id
2692: AND pol.po_header_id =

Line 2700: FROM po_line_locations_all poll,

2696: OR ( poh.type_lookup_code = 'QUOTATION'
2697: AND ( poh.status_lookup_code = 'A' )
2698: AND ( poh.approval_required_flag = 'N' )
2699: AND ( EXISTS (SELECT 'x'
2700: FROM po_line_locations_all poll,
2701: po_lines_all pol
2702: WHERE poll.po_line_id = pol.po_line_id
2703: AND pol.item_id = l_item_id
2704: AND pol.po_header_id = poh.po_header_id

Line 2708: FROM po_line_locations_all poll,

2704: AND pol.po_header_id = poh.po_header_id
2705: AND Trunc(SYSDATE) <=
2706: Nvl(poh.end_date, SYSDATE + 1))
2707: OR NOT EXISTS (SELECT 'no shipments exists'
2708: FROM po_line_locations_all poll,
2709: po_lines_all pol
2710: WHERE poll.po_line_id = pol.po_line_id
2711: AND pol.item_id = l_item_id
2712: AND pol.po_header_id =

Line 2779: po_line_locations_all poll,

2775: AND ( poh.status_lookup_code = 'A' )
2776: AND ( poh.approval_required_flag = 'Y' )
2777: AND ( EXISTS (SELECT 'x'
2778: FROM po_quotation_approvals poqa,
2779: po_line_locations_all poll,
2780: po_lines_all pol
2781: WHERE poqa.approval_type IS NOT NULL
2782: AND poqa.line_location_id =
2783: poll.line_location_id

Line 2790: FROM po_line_locations_all poll,

2786: AND pol.po_header_id = poh.po_header_id
2787: AND Trunc(SYSDATE) <=
2788: Nvl(poh.end_date, SYSDATE + 1))
2789: OR NOT EXISTS (SELECT 'no shipments exists'
2790: FROM po_line_locations_all poll,
2791: po_lines_all pol
2792: WHERE poll.po_line_id = pol.po_line_id
2793: AND pol.category_id =
2794: l_category_id

Line 2803: FROM po_line_locations_all poll,

2799: OR ( poh.type_lookup_code = 'QUOTATION'
2800: AND ( poh.status_lookup_code = 'A' )
2801: AND ( poh.approval_required_flag = 'N' )
2802: AND ( EXISTS (SELECT 'x'
2803: FROM po_line_locations_all poll,
2804: po_lines_all pol
2805: WHERE poll.po_line_id = pol.po_line_id
2806: AND pol.category_id = l_category_id
2807: AND pol.po_header_id = poh.po_header_id

Line 2811: FROM po_line_locations_all poll,

2807: AND pol.po_header_id = poh.po_header_id
2808: AND Trunc(SYSDATE) <=
2809: Nvl(poh.end_date, SYSDATE + 1))
2810: OR NOT EXISTS (SELECT 'no shipments exists'
2811: FROM po_line_locations_all poll,
2812: po_lines_all pol
2813: WHERE poll.po_line_id = pol.po_line_id
2814: AND pol.category_id =
2815: l_category_id

Line 2933: po_line_locations_all poll

2929: OR ( poh.type_lookup_code = 'QUOTATION'
2930: AND ( poh.approval_required_flag = 'Y' )
2931: AND ( EXISTS (SELECT 1
2932: FROM po_quotation_approvals poqa,
2933: po_line_locations_all poll
2934: WHERE poqa.approval_type IS NOT NULL
2935: AND poqa.line_location_id =
2936: poll.line_location_id
2937: AND poll.po_line_id = pol.po_line_id

Line 2943: FROM po_line_locations_all poll

2939: AND pol.po_header_id = poh.po_header_id
2940: AND SYSDATE <
2941: Nvl(poh.end_date, SYSDATE + 1))
2942: OR NOT EXISTS (SELECT 'no shipments exists'
2943: FROM po_line_locations_all poll
2944: WHERE poll.po_line_id = pol.po_line_id
2945: AND pol.item_id = l_item_id
2946: AND pol.po_header_id =
2947: poh.po_header_id

Line 2953: FROM po_line_locations_all poll

2949: )
2950: OR ( poh.type_lookup_code = 'QUOTATION'
2951: AND ( poh.approval_required_flag = 'N' )
2952: AND ( EXISTS (SELECT 1
2953: FROM po_line_locations_all poll
2954: WHERE poll.po_line_id = pol.po_line_id
2955: AND pol.item_id = l_item_id
2956: AND pol.po_header_id = poh.po_header_id
2957: AND SYSDATE <

Line 2960: FROM po_line_locations_all poll

2956: AND pol.po_header_id = poh.po_header_id
2957: AND SYSDATE <
2958: Nvl(poh.end_date, SYSDATE + 1))
2959: OR NOT EXISTS (SELECT 'no shipments exists'
2960: FROM po_line_locations_all poll
2961: WHERE poll.po_line_id = pol.po_line_id
2962: AND pol.item_id = l_item_id
2963: AND pol.po_header_id =
2964: poh.po_header_id

Line 2986: po_line_locations_all poll

2982: OR ( poh.type_lookup_code = 'QUOTATION'
2983: AND ( poh.approval_required_flag = 'Y' )
2984: AND ( EXISTS (SELECT *
2985: FROM po_quotation_approvals poqa,
2986: po_line_locations_all poll
2987: WHERE poqa.approval_type IS NOT NULL
2988: AND poqa.line_location_id =
2989: poll.line_location_id
2990: AND poll.po_line_id = pol.po_line_id

Line 2996: FROM po_line_locations_all poll

2992: AND pol.po_header_id = poh.po_header_id
2993: AND SYSDATE < Nvl(poh.end_date, SYSDATE
2994: + 1))
2995: OR NOT EXISTS (SELECT 'no shipments exists'
2996: FROM po_line_locations_all poll
2997: WHERE poll.po_line_id = pol.po_line_id
2998: AND pol.category_id =
2999: l_category_id
3000: AND pol.po_header_id =

Line 3007: FROM po_line_locations_all poll

3003: )
3004: OR ( poh.type_lookup_code = 'QUOTATION'
3005: AND ( poh.approval_required_flag = 'N' )
3006: AND ( EXISTS (SELECT *
3007: FROM po_line_locations_all poll
3008: WHERE poll.po_line_id = pol.po_line_id
3009: AND pol.category_id = l_category_id
3010: AND pol.po_header_id = poh.po_header_id
3011: AND SYSDATE < Nvl(poh.end_date, SYSDATE

Line 3014: FROM po_line_locations_all poll

3010: AND pol.po_header_id = poh.po_header_id
3011: AND SYSDATE < Nvl(poh.end_date, SYSDATE
3012: + 1))
3013: OR NOT EXISTS (SELECT 'no shipments exists'
3014: FROM po_line_locations_all poll
3015: WHERE poll.po_line_id = pol.po_line_id
3016: AND pol.category_id =
3017: l_category_id
3018: AND pol.po_header_id =