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 1714: icx_cat_categories_tl ic,

1710: po_lines_all pl,
1711: po_ga_org_assignments ga,
1712: po_attribute_values_tlp po_tlp,
1713: po_line_types_b pltb,
1714: icx_cat_categories_tl ic,
1715: po_vendors pv
1716: WHERE ph.po_header_id = pl.po_header_id
1717: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1718: AND ph.po_header_id = ga.po_header_id (+)

Line 1814: icx_cat_categories_tl ic,

1810: po_lines_all pl,
1811: po_ga_org_assignments ga,
1812: po_attribute_values_tlp po_tlp,
1813: po_line_types_b pltb,
1814: icx_cat_categories_tl ic,
1815: po_vendors pv
1816: WHERE ph.po_header_id = pl.po_header_id
1817: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1818: AND ph.po_header_id = ga.po_header_id (+)

Line 2365: icx_cat_categories_tl ic,

2361: po_lines_all pl,
2362: po_session_gt pogt,
2363: po_attribute_values_tlp po_tlp,
2364: po_line_types_b pltb,
2365: icx_cat_categories_tl ic,
2366: po_vendors pv
2367: WHERE ph.po_header_id = pl.po_header_id
2368: AND ph.type_lookup_code = 'QUOTATION'
2369: AND pogt.key = p_key