APPS.POA_DBI_COM_C dependencies on PO_COMMODITY_CATEGORIES

Line 161: INSERT INTO po_commodity_categories (

157: SELECT commodity_id INTO v_commodity_id from po_commodities_b
158: WHERE commodity_code=v_commodity_code;
159:
160: -- Insert Record in the table
161: INSERT INTO po_commodity_categories (
162: commodity_id,
163: category_id,
164: creation_date,
165: created_by,

Line 182: AND NOT EXISTS ( SELECT 1 FROM po_commodity_categories pcc

178: FROM
179: mtl_category_set_valid_cats mcat
180: WHERE
181: mcat.category_set_id = 2 -- Consider only categories of the purchasing category set
182: AND NOT EXISTS ( SELECT 1 FROM po_commodity_categories pcc
183: WHERE pcc.category_id=mcat.category_id)
184: );
185:
186: