DBA Data[Home] [Help]

APPS.ENI_CONFIG_ITEMS_PKG dependencies on ENI_OLTP_ITEM_STAR

Line 40: INSERT INTO eni_oltp_item_star(

36: END IF;
37:
38: END LOOP;
39:
40: INSERT INTO eni_oltp_item_star(
41: id,
42: value,
43: inventory_item_id,
44: organization_id,

Line 90: AND NOT EXISTS(SELECT null FROM eni_oltp_item_star

86: AND mic1.organization_id(+) = mti.organization_id
87: AND mic1.inventory_item_id(+) = mti.inventory_item_id
88: AND mic1.category_id = kfv1.category_id (+)
89: AND mic1.category_set_id(+) = l_vbh_category_set
90: AND NOT EXISTS(SELECT null FROM eni_oltp_item_star
91: WHERE inventory_item_id = l_inventory_item_id
92: AND organization_id = mti.organization_id);
93:
94: X_RETURN_STATUS := 'S';