APPS.PO_ASL_API_PUB dependencies on PO_LINES_ALL

Line 2678: po_lines_all pol

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
2682: AND poll.po_line_id = pol.po_line_id

Line 2689: po_lines_all pol

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 =
2693: poh.po_header_id

Line 2701: po_lines_all pol

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
2705: AND Trunc(SYSDATE) <=

Line 2709: po_lines_all pol

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 =
2713: poh.po_header_id

Line 2733: FROM po_lines_all pol

2729: poga.vendor_site_id)
2730: AND poga.enabled_flag = 'Y') ) )
2731: AND ( poh.type_lookup_code = 'CONTRACT'
2732: OR EXISTS (SELECT 'x'
2733: FROM po_lines_all pol
2734: WHERE pol.po_header_id = poh.po_header_id
2735: AND pol.item_id = l_item_id
2736: AND Nvl(pol.cancel_flag, 'N') = 'N') )
2737: AND Trunc(SYSDATE) <= Nvl(poh.end_date, SYSDATE + 1)

Line 2780: po_lines_all pol

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
2784: AND poll.po_line_id = pol.po_line_id

Line 2791: po_lines_all pol

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
2795: AND pol.po_header_id =

Line 2804: po_lines_all pol

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
2808: AND Trunc(SYSDATE) <=

Line 2812: po_lines_all pol

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
2816: AND pol.po_header_id =

Line 2836: FROM po_lines_all pol

2832: l_vendor_site_id)
2833: AND poga.enabled_flag = 'Y') ) )
2834: AND ( poh.type_lookup_code = 'CONTRACT'
2835: OR EXISTS (SELECT 'x'
2836: FROM po_lines_all pol
2837: WHERE pol.po_header_id = poh.po_header_id
2838: AND pol.category_id = l_category_id
2839: AND Nvl(pol.cancel_flag, 'N') = 'N') )
2840: AND Trunc(SYSDATE) <= Nvl(poh.end_date, SYSDATE + 1)

Line 2921: FROM po_lines_all pol,

2917: THEN
2918: po_asl_api_pvt.log('inside if :');
2919: SELECT pol.po_line_id
2920: INTO l_line_id
2921: FROM po_lines_all pol,
2922: fnd_currencies_vl fnc,
2923: po_headers_all poh
2924: WHERE pol.po_header_id = p_header_id
2925: AND pol.item_id = l_item_id

Line 2974: FROM po_lines_all pol,

2970: THEN
2971: po_asl_api_pvt.log('inside else :');
2972: SELECT pol.po_line_id
2973: INTO l_line_id
2974: FROM po_lines_all pol,
2975: fnd_currencies_vl fnc,
2976: po_headers_all poh
2977: WHERE pol.po_header_id = p_header_id
2978: AND pol.category_id = l_category_id