eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on EGO_ITEM_PEOPLE_INTF

Line 140: FROM EGO_ITEM_PEOPLE_INTF

136: SELECT
137: ORGANIZATION_ID,
138: TRANSACTION_ID,
139: PROCESS_STATUS
140: FROM EGO_ITEM_PEOPLE_INTF
141: WHERE DATA_SET_ID = p_data_set_id
142: AND PROCESS_STATUS IN (33379, 33389);
143:
144: CURSOR c_ssxref_null_eai IS

Line 233: UPDATE EGO_ITEM_PEOPLE_INTF EIPI

229: )
230: );
231:
232: -- EIPI
233: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
234: SET PROCESS_STATUS = (CASE WHEN EIPI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
235: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
236: PROGRAM_APPLICATION_ID = l_prog_appid,
237: PROGRAM_ID = l_prog_id,

Line 449: ,'EGO_ITEM_PEOPLE_INTF'

445: ,l_request_id
446: ,i.TRANSACTION_ID
447: ,l_msg_text
448: ,'SOURCE_SYSTEM_REFERENCE'
449: ,'EGO_ITEM_PEOPLE_INTF'
450: ,'INV_IOI_ERR_SSXREF_IS_NULL_05'--bug 11894684, replace INV_IOI_ERR
451: ,l_err_text);
452: ELSIF i.PROCESS_STATUS = 33389 THEN
453: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 465: ,'EGO_ITEM_PEOPLE_INTF'

461: ,l_request_id
462: ,i.TRANSACTION_ID
463: ,l_msg_text
464: ,'SOURCE_SYSTEM_ID'
465: ,'EGO_ITEM_PEOPLE_INTF'
466: ,'INV_IOI_ERR_SSXID_INVALID_05'--bug 11894684, replace INV_IOI_ERR
467: ,l_err_text);
468: END IF;
469: END LOOP;

Line 568: UPDATE EGO_ITEM_PEOPLE_INTF

564: SET PROCESS_STATUS =3
565: WHERE PROCESS_STATUS IN (33379, 33389)
566: AND DATA_SET_ID = p_data_set_id;
567:
568: UPDATE EGO_ITEM_PEOPLE_INTF
569: SET PROCESS_STATUS =3
570: WHERE PROCESS_STATUS IN (33379, 33389)
571: AND DATA_SET_ID = p_data_set_id;
572:

Line 681: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF

677: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
678: END IF;
679:
680: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);
681: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF
682: SELECT COUNT(1) INTO l_records
683: FROM EGO_ITEM_PEOPLE_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:

Line 683: FROM EGO_ITEM_PEOPLE_INTF

679:
680: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);
681: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF
682: SELECT COUNT(1) INTO l_records
683: FROM EGO_ITEM_PEOPLE_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');

Line 687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');

683: FROM EGO_ITEM_PEOPLE_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_AML_INTF

Line 688: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');

684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_AML_INTF
692: SELECT COUNT(1) INTO l_records

Line 6595: UPDATE EGO_ITEM_PEOPLE_INTF EIPI

6591: WHERE DATA_SET_ID = p_data_set_id AND
6592: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND
6593: ORGANIZATION_ID IS NULL;
6594:
6595: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
6596: SET ORGANIZATION_ID =
6597: CASE
6598: WHEN ORGANIZATION_CODE IS NOT NULL
6599: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIPI.ORGANIZATION_CODE)

Line 6806: UPDATE EGO_ITEM_PEOPLE_INTF MIPI

6802: AND PROCESS_FLAG = 1
6803: AND ITEM_NUMBER IS NULL
6804: AND INVENTORY_ITEM_ID IS NOT NULL;
6805:
6806: UPDATE EGO_ITEM_PEOPLE_INTF MIPI
6807: SET item_number = (SELECT CONCATENATED_SEGMENTS
6808: FROM MTL_SYSTEM_ITEMS_KFV
6809: WHERE INVENTORY_ITEM_ID = MIPI.INVENTORY_ITEM_ID
6810: AND ORGANIZATION_ID = MIPI.ORGANIZATION_ID)

Line 7031: UPDATE EGO_ITEM_PEOPLE_INTF

7027: SET PROCESS_STATUS = 0
7028: WHERE DATA_SET_ID = p_data_set_id AND
7029: PROCESS_STATUS IS NULL;
7030:
7031: UPDATE EGO_ITEM_PEOPLE_INTF
7032: SET PROCESS_STATUS = 0
7033: WHERE DATA_SET_ID = p_data_set_id AND
7034: PROCESS_STATUS IS NULL;
7035:

Line 7969: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.

7965:
7966: /*
7967: * This method populates the child entities with PK values.
7968: * This method populates the other interface tables like MTL_ITEM_REVISION_INTERFACE,
7969: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7970: * with the inventory item id/number and organization id/code.
7971: */
7972: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7973: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

Line 8895: UPDATE EGO_ITEM_PEOPLE_INTF EIPI

8891: AND MSII.ORGANIZATION_ID = l_org_id);
8892:
8893: Debug_Conc_Log('Resolve_Child_Entities - After resolving item revisions interface table for revision' );
8894: -- updating item_number, item_id from MSII table
8895: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
8896: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8897: (SELECT
8898: 1,
8899: (CASE

Line 9185: UPDATE EGO_ITEM_PEOPLE_INTF EIPI

9181: Debug_Conc_Log('Resolve_Child_Entities - After updating categories intf table for items that has XXref');
9182:
9183: -- updating the item people
9184: l_sql := q'#
9185: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
9186: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9187: (SELECT
9188: 1,
9189: NVL(EIPI.TRANSACTION_TYPE, 'SYNC'),

Line 9683: UPDATE EGO_ITEM_PEOPLE_INTF eipi

9679: );
9680: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9681:
9682: -- updating item people
9683: UPDATE EGO_ITEM_PEOPLE_INTF eipi
9684: SET PROCESS_STATUS = 1
9685: WHERE ( INVENTORY_ITEM_ID = l_item_id
9686: OR ( ITEM_NUMBER = l_item_number
9687: AND INVENTORY_ITEM_ID IS NULL

Line 9786: UPDATE EGO_ITEM_PEOPLE_INTF eipi

9782: );
9783: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9784:
9785: -- updating item people
9786: UPDATE EGO_ITEM_PEOPLE_INTF eipi
9787: SET PROCESS_STATUS = 1
9788: WHERE ITEM_NUMBER = l_item_number
9789: AND PROCESS_STATUS = 3
9790: AND DATA_SET_ID = p_batch_id

Line 10048: UPDATE EGO_ITEM_PEOPLE_INTF eipi

10044: );
10045: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10046:
10047: -- updating item people
10048: UPDATE EGO_ITEM_PEOPLE_INTF eipi
10049: SET PROCESS_STATUS = 1
10050: WHERE SOURCE_SYSTEM_ID = l_ss_id
10051: AND SOURCE_SYSTEM_REFERENCE = l_ssr
10052: AND PROCESS_STATUS = 3

Line 12642: FROM EGO_ITEM_PEOPLE_INTF eipi

12638: THEN 1
12639: ELSE NULL
12640: END
12641: ) UPDATE_CNT
12642: FROM EGO_ITEM_PEOPLE_INTF eipi
12643: WHERE eipi.DATA_SET_ID = p_set_process_id
12644: AND EXISTS
12645: (
12646: SELECT NULL