DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_PODOCS_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 125: icx_cat_categories_tl ic,

121: po_ga_org_assignments ga,
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 (+)

Line 260: icx_cat_categories_tl ic,

256: po_ga_org_assignments ga,
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 (+)

Line 1700: icx_cat_categories_tl ic,

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,
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 (+)

Line 1800: icx_cat_categories_tl ic,

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,
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 (+)

Line 2351: icx_cat_categories_tl ic,

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,
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