DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 813: l_temp ego_mtl_sy_items_ext_b.item_catalog_group_id%TYPE;

809:
810: FUNCTION icc_changed (p_inventory_item_id IN NUMBER,
811: p_new_icc_id IN NUMBER) RETURN BOOLEAN IS
812:
813: l_temp ego_mtl_sy_items_ext_b.item_catalog_group_id%TYPE;
814:
815: CURSOR c IS
816: SELECT ems.item_catalog_group_id
817: FROM ego_mtl_sy_items_ext_b ems

Line 817: FROM ego_mtl_sy_items_ext_b ems

813: l_temp ego_mtl_sy_items_ext_b.item_catalog_group_id%TYPE;
814:
815: CURSOR c IS
816: SELECT ems.item_catalog_group_id
817: FROM ego_mtl_sy_items_ext_b ems
818: WHERE ems.inventory_item_id = p_inventory_item_id
819: AND ems.item_catalog_group_id <> p_new_icc_id
820: AND rownum = 1;
821:

Line 889: FROM ego_mtl_sy_items_ext_b

885:
886: code_debug('delete_old_icc_attrs : ' || ' Deleted ' || SQL%ROWCOUNT || ' from TL');
887:
888: DELETE
889: FROM ego_mtl_sy_items_ext_b
890: WHERE inventory_item_id = p_inventory_item_id
891: AND attr_group_id NOT IN
892: (SELECT ATTR_GROUP_ID
893: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,

Line 2332: INSERT INTO EGO_MTL_SY_ITEMS_EXT_B

2328:
2329: ----------------------------------------------------------------------
2330: -- Insert a row for every newly created item in the interface table --
2331: ----------------------------------------------------------------------
2332: INSERT INTO EGO_MTL_SY_ITEMS_EXT_B
2333: (
2334: EXTENSION_ID
2335: ,ORGANIZATION_ID
2336: ,INVENTORY_ITEM_ID

Line 2401: ,EGO_MTL_SY_ITEMS_EXT_B EXT

2397: ,EXT.LAST_UPDATE_DATE
2398: ,NVL(M.MESSAGE_TEXT,'Long Description')
2399: ,43102 --Added for bug 6155995
2400: FROM MTL_SYSTEM_ITEMS_INTERFACE MTL
2401: ,EGO_MTL_SY_ITEMS_EXT_B EXT
2402: ,FND_LANGUAGES L
2403: ,FND_NEW_MESSAGES M
2404: WHERE MTL.SET_PROCESS_ID = p_set_process_id
2405: AND MTL.PROCESS_FLAG = 4