APPS.ICX_CAT_POPULATE_PODOCS_PVT dependencies on PO_HEADERS_ALL

Line 119: FROM po_headers_all ph,

115: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
116: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
117: TRUNC(SYSDATE) system_date,
118: ph.created_by
119: FROM po_headers_all ph,
120: po_lines_all pl,
121: po_ga_org_assignments ga,
122: po_session_gt pogt,
123: po_attribute_values_tlp po_tlp,

Line 254: FROM po_headers_all ph,

250: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
251: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
252: TRUNC(SYSDATE) system_date,
253: ph.created_by
254: FROM po_headers_all ph,
255: po_lines_all pl,
256: po_ga_org_assignments ga,
257: po_session_gt pogt,
258: po_attribute_values_tlp po_tlp,

Line 796: po_headers_all ph,

792: ph.global_agreement_flag,
793: --For global agreement status
794: NVL(t.enabled_flag, 'N') enabled_flag
795: FROM po_ga_org_assignments t,
796: po_headers_all ph,
797: po_lines_all pl,
798: icx_cat_items_ctx_hdrs_tlp ctxIn,
799: po_vendors pv,
800: po_line_types_b pltb

Line 874: po_headers_all ph,

870: ph.global_agreement_flag,
871: --For global agreement status
872: NVL(t.enabled_flag, 'N') enabled_flag
873: FROM po_ga_org_assignments t,
874: po_headers_all ph,
875: po_lines_all pl,
876: icx_cat_items_ctx_hdrs_tlp ctxIn,
877: po_vendors pv,
878: po_line_types_b pltb

Line 992: po_headers_all ph,

988: pv.vendor_name supplier,
989: ph.global_agreement_flag,
990: NVL(t.enabled_flag, 'N') enabled_flag
991: FROM po_ga_org_assignments t,
992: po_headers_all ph,
993: po_lines_all pl,
994: po_session_gt pogt,
995: icx_cat_items_ctx_hdrs_tlp ctxIn,
996: po_vendors pv,

Line 1114: po_headers_all ph,

1110: pv.vendor_name supplier,
1111: ph.global_agreement_flag,
1112: NVL(t.enabled_flag, 'N') enabled_flag
1113: FROM po_ga_org_assignments t,
1114: po_headers_all ph,
1115: po_lines_all pl,
1116: po_session_gt pogt,
1117: icx_cat_items_ctx_hdrs_tlp ctxIn,
1118: po_vendors pv,

Line 1355: FROM po_headers_all

1351:
1352: --bug 16374319 begin
1353: SELECT NVL(authorization_status, 'INCOMPLETE')
1354: INTO l_authorization_status
1355: FROM po_headers_all
1356: WHERE po_header_id = l_po_header_id_tbl(i);
1357:
1358: l_err_loc := 800;
1359: IF (l_authorization_status = 'APPROVED'

Line 1709: FROM po_headers_all ph,

1705: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
1706: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
1707: TRUNC(SYSDATE) system_date,
1708: ph.created_by
1709: FROM po_headers_all ph,
1710: po_lines_all pl,
1711: po_ga_org_assignments ga,
1712: po_attribute_values_tlp po_tlp,
1713: po_line_types_b pltb,

Line 1809: FROM po_headers_all ph,

1805: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
1806: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
1807: TRUNC(SYSDATE) system_date,
1808: ph.created_by
1809: FROM po_headers_all ph,
1810: po_lines_all pl,
1811: po_ga_org_assignments ga,
1812: po_attribute_values_tlp po_tlp,
1813: po_line_types_b pltb,

Line 2360: FROM po_headers_all ph,

2356: ph.agent_id buyer_id,
2357: ph.vendor_contact_id supplier_contact_id,
2358: pltb.order_type_lookup_code,
2359: pv.vendor_name supplier
2360: FROM po_headers_all ph,
2361: po_lines_all pl,
2362: po_session_gt pogt,
2363: po_attribute_values_tlp po_tlp,
2364: po_line_types_b pltb,