APPS.ICX_CAT_POPULATE_PODOCS_PVT dependencies on PO_VENDORS

Line 126: po_vendors pv

122: po_session_gt pogt,
123: po_attribute_values_tlp po_tlp,
124: po_line_types_b pltb,
125: icx_cat_categories_tl ic,
126: po_vendors pv
127: WHERE ph.po_header_id = pl.po_header_id
128: AND ph.type_lookup_code = 'BLANKET'
129: AND ph.po_header_id = ga.po_header_id (+)
130: AND ph.org_id = ga.organization_id (+)

Line 261: po_vendors pv

257: po_session_gt pogt,
258: po_attribute_values_tlp po_tlp,
259: po_line_types_b pltb,
260: icx_cat_categories_tl ic,
261: po_vendors pv
262: WHERE ph.po_header_id = pl.po_header_id
263: AND ph.type_lookup_code = 'BLANKET'
264: AND ph.po_header_id = ga.po_header_id (+)
265: AND ph.org_id = ga.organization_id (+)

Line 795: po_vendors pv,

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'
798: AND ph.po_header_id = t.po_header_id
799: AND ph.org_id <> t.organization_id

Line 873: po_vendors pv,

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'
876: AND ph.po_header_id = t.po_header_id
877: AND ph.org_id <> t.organization_id

Line 992: po_vendors pv,

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
994: WHERE ph.global_agreement_flag = 'Y'
995: AND ph.po_header_id = t.po_header_id
996: AND ph.org_id <> t.organization_id

Line 1114: po_vendors pv,

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
1116: WHERE ph.global_agreement_flag = 'Y'
1117: AND ph.po_header_id = t.po_header_id
1118: AND ph.org_id <> t.organization_id

Line 1701: po_vendors pv

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,
1701: po_vendors pv
1702: WHERE ph.po_header_id = pl.po_header_id
1703: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1704: AND ph.po_header_id = ga.po_header_id (+)
1705: AND ph.org_id = ga.organization_id (+)

Line 1801: po_vendors pv

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,
1801: po_vendors pv
1802: WHERE ph.po_header_id = pl.po_header_id
1803: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1804: AND ph.po_header_id = ga.po_header_id (+)
1805: AND ph.org_id = ga.organization_id (+)

Line 2352: po_vendors pv

2348: po_session_gt pogt,
2349: po_attribute_values_tlp po_tlp,
2350: po_line_types_b pltb,
2351: icx_cat_categories_tl ic,
2352: po_vendors pv
2353: WHERE ph.po_header_id = pl.po_header_id
2354: AND ph.type_lookup_code = 'QUOTATION'
2355: AND pogt.key = p_key
2356: AND pl.po_line_id = pogt.index_num1