DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_ITEM_CATEGORIES

Line 890: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE

886: ,x_msg_data OUT NOCOPY VARCHAR2)
887: IS
888: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
889: BEGIN
890: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE
891: ( SET_PROCESS_ID,
892: PROCESS_FLAG,
893: TRANSACTION_TYPE,
894: INVENTORY_ITEM_ID,

Line 915: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic

911: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
912: WHERE msib.STYLE_ITEM_ID = p_style_item_id
913: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
914: AND mp.ORGANIZATION_ID = p_organization_id
915: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic
916: WHERE mic.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID
917: AND mic.ORGANIZATION_ID = p_organization_id
918: AND mic.CATEGORY_SET_ID = p_category_set_id
919: AND mic.CATEGORY_ID = p_category_id