DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_PODOCS_PVT dependencies on PO_LINES_ALL

Line 120: po_lines_all pl,

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,
124: po_line_types_b pltb,

Line 255: po_lines_all pl,

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,
259: po_line_types_b pltb,

Line 793: po_lines_all pl,

789: --For global agreement status
790: NVL(t.enabled_flag, 'N') enabled_flag
791: FROM po_ga_org_assignments t,
792: po_headers_all ph,
793: po_lines_all pl,
794: icx_cat_items_ctx_hdrs_tlp ctxIn,
795: po_vendors pv,
796: po_line_types_b pltb
797: WHERE ph.global_agreement_flag = 'Y'

Line 871: po_lines_all pl,

867: --For global agreement status
868: NVL(t.enabled_flag, 'N') enabled_flag
869: FROM po_ga_org_assignments t,
870: po_headers_all ph,
871: po_lines_all pl,
872: icx_cat_items_ctx_hdrs_tlp ctxIn,
873: po_vendors pv,
874: po_line_types_b pltb
875: WHERE ph.global_agreement_flag = 'Y'

Line 989: po_lines_all pl,

985: ph.global_agreement_flag,
986: NVL(t.enabled_flag, 'N') enabled_flag
987: FROM po_ga_org_assignments t,
988: po_headers_all ph,
989: po_lines_all pl,
990: po_session_gt pogt,
991: icx_cat_items_ctx_hdrs_tlp ctxIn,
992: po_vendors pv,
993: po_line_types_b pltb

Line 1111: po_lines_all pl,

1107: ph.global_agreement_flag,
1108: NVL(t.enabled_flag, 'N') enabled_flag
1109: FROM po_ga_org_assignments t,
1110: po_headers_all ph,
1111: po_lines_all pl,
1112: po_session_gt pogt,
1113: icx_cat_items_ctx_hdrs_tlp ctxIn,
1114: po_vendors pv,
1115: po_line_types_b pltb

Line 1696: po_lines_all pl,

1692: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
1693: TRUNC(SYSDATE) system_date,
1694: ph.created_by
1695: FROM po_headers_all ph,
1696: po_lines_all pl,
1697: po_ga_org_assignments ga,
1698: po_attribute_values_tlp po_tlp,
1699: po_line_types_b pltb,
1700: icx_cat_categories_tl ic,

Line 1796: po_lines_all pl,

1792: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) expiration_date,
1793: TRUNC(SYSDATE) system_date,
1794: ph.created_by
1795: FROM po_headers_all ph,
1796: po_lines_all pl,
1797: po_ga_org_assignments ga,
1798: po_attribute_values_tlp po_tlp,
1799: po_line_types_b pltb,
1800: icx_cat_categories_tl ic,

Line 2347: po_lines_all pl,

2343: ph.vendor_contact_id supplier_contact_id,
2344: pltb.order_type_lookup_code,
2345: pv.vendor_name supplier
2346: FROM po_headers_all ph,
2347: po_lines_all pl,
2348: po_session_gt pogt,
2349: po_attribute_values_tlp po_tlp,
2350: po_line_types_b pltb,
2351: icx_cat_categories_tl ic,