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 MTL_ITEM_CATEGORIES_INTERFACE

Line 122: FROM MTL_ITEM_CATEGORIES_INTERFACE

118: SELECT
119: ORGANIZATION_ID,
120: TRANSACTION_ID,
121: PROCESS_FLAG
122: FROM MTL_ITEM_CATEGORIES_INTERFACE
123: WHERE SET_PROCESS_ID = p_data_set_id
124: AND PROCESS_FLAG IN (33379, 33389);
125:
126: CURSOR c_ssxref_null_eiuai IS

Line 199: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

195: )
196: );
197:
198: -- MICI
199: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
200: SET PROCESS_FLAG = (CASE WHEN MICI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
201: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
202: PROGRAM_APPLICATION_ID = l_prog_appid,
203: PROGRAM_ID = l_prog_id,

Line 375: ,'MTL_ITEM_CATEGORIES_INTERFACE'

371: ,l_request_id
372: ,i.TRANSACTION_ID
373: ,l_msg_text
374: ,'SOURCE_SYSTEM_REFERENCE'
375: ,'MTL_ITEM_CATEGORIES_INTERFACE'
376: ,'INV_IOI_ERR_SSXREF_IS_NULL_03'--bug 11894684, replace INV_IOI_ERR
377: ,l_err_text);
378: ELSIF i.PROCESS_FLAG = 33389 THEN
379: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 391: ,'MTL_ITEM_CATEGORIES_INTERFACE'

387: ,l_request_id
388: ,i.TRANSACTION_ID
389: ,l_msg_text
390: ,'SOURCE_SYSTEM_ID'
391: ,'MTL_ITEM_CATEGORIES_INTERFACE'
392: ,'INV_IOI_ERR_SSXID_INVALID_03'--bug 11894684, replace INV_IOI_ERR
393: ,l_err_text);
394: END IF;
395: END LOOP;

Line 558: UPDATE MTL_ITEM_CATEGORIES_INTERFACE

554: SET PROCESS_FLAG =3
555: WHERE PROCESS_FLAG IN (33379, 33389)
556: AND SET_PROCESS_ID = p_data_set_id;
557:
558: UPDATE MTL_ITEM_CATEGORIES_INTERFACE
559: SET PROCESS_FLAG =3
560: WHERE PROCESS_FLAG IN (33379, 33389)
561: AND SET_PROCESS_ID = p_data_set_id;
562:

Line 670: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE

666: END IF;
667: */
668: -- Bug 12669090 : End
669:
670: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE
671: SELECT COUNT(1) INTO l_records
672: FROM MTL_ITEM_CATEGORIES_INTERFACE
673: WHERE SET_PROCESS_ID = p_data_set_id;
674:

Line 672: FROM MTL_ITEM_CATEGORIES_INTERFACE

668: -- Bug 12669090 : End
669:
670: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE
671: SELECT COUNT(1) INTO l_records
672: FROM MTL_ITEM_CATEGORIES_INTERFACE
673: WHERE SET_PROCESS_ID = p_data_set_id;
674:
675: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

Line 676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

672: FROM MTL_ITEM_CATEGORIES_INTERFACE
673: WHERE SET_PROCESS_ID = p_data_set_id;
674:
675: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
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);

Line 677: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');

673: WHERE SET_PROCESS_ID = p_data_set_id;
674:
675: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
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

Line 4077: SUBTYPE MICI_ROW IS MTL_ITEM_CATEGORIES_INTERFACE%ROWTYPE;

4073: PROCEDURE Merge_Categories_For_Import( p_batch_id IN NUMBER
4074: , p_master_org_id IN NUMBER
4075: )
4076: IS
4077: SUBTYPE MICI_ROW IS MTL_ITEM_CATEGORIES_INTERFACE%ROWTYPE;
4078: TYPE MICI_ROWS IS TABLE OF MICI_ROW INDEX BY BINARY_INTEGER;
4079:
4080: /*
4081: * Note that the organization_id column is filled in from the organization_code and batch organization_id

Line 4092: FROM MTL_ITEM_CATEGORIES_INTERFACE mici

4088: ROWID rid,
4089: COUNT( * ) OVER ( PARTITION BY ITEM_NUMBER, ORGANIZATION_ID, CATEGORY_SET_NAME, CATEGORY_NAME ) cnt,
4090: RANK() OVER ( ORDER BY ITEM_NUMBER, ORGANIZATION_ID, CATEGORY_SET_NAME, CATEGORY_NAME ) rnk,
4091: mici.*
4092: FROM MTL_ITEM_CATEGORIES_INTERFACE mici
4093: WHERE PROCESS_FLAG = 1
4094: AND SET_PROCESS_ID = p_batch_id
4095: AND ITEM_NUMBER IS NOT NULL
4096: AND ORGANIZATION_ID IS NOT NULL

Line 4117: l_candidate_trans MTL_ITEM_CATEGORIES_INTERFACE.TRANSACTION_TYPE%TYPE;

4113: l_merged_row MICI_ROW;
4114: l_old_rows TARGET_ROWS;
4115: l_old_rowids UROWID_TABLE;
4116:
4117: l_candidate_trans MTL_ITEM_CATEGORIES_INTERFACE.TRANSACTION_TYPE%TYPE;
4118:
4119: l_mrow_ix PLS_INTEGER := 0;
4120: l_new_row_idx PLS_INTEGER := 0;
4121: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 4128: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

4124: BEGIN
4125: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4126: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4127:
4128: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4129: SET CATEGORY_SET_NAME = NVL( mici.CATEGORY_SET_NAME,
4130: ( SELECT mcs.CATEGORY_SET_NAME
4131: FROM MTL_CATEGORY_SETS mcs
4132: WHERE mcs.CATEGORY_SET_ID = mici.CATEGORY_SET_ID

Line 4147: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

4143: )
4144: AND SET_PROCESS_ID = p_batch_id
4145: AND PROCESS_FLAG = 1;
4146:
4147: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4148: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4149: FROM MTL_SYSTEM_ITEMS_KFV
4150: WHERE INVENTORY_ITEM_ID = mici.INVENTORY_ITEM_ID
4151: AND ORGANIZATION_ID = mici.ORGANIZATION_ID)

Line 4309: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE

4305: IF l_merged_rows IS NOT NULL THEN
4306: -- delete
4307: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
4308: FORALL rid_ix IN INDICES OF l_old_rowids
4309: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE
4310: WHERE ROWID = l_old_rowids( rid_ix );
4311: -- insert
4312: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4313: FORALL row_index IN INDICES OF l_merged_rows

Line 4314: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE

4310: WHERE ROWID = l_old_rowids( rid_ix );
4311: -- insert
4312: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4313: FORALL row_index IN INDICES OF l_merged_rows
4314: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE
4315: VALUES l_merged_rows( row_index );
4316: END IF;
4317: END IF; -- ENDS IF l_old_rows.count <> 0
4318: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 5024: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

5020: AND PROCESS_FLAG = 111;
5021:
5022: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Revisions.' );
5023: -- processing category assignments
5024: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
5025: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
5026: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
5027: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged
5028: WHERE mici_merged.ITEM_NUMBER = mici.ITEM_NUMBER

Line 5027: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged

5023: -- processing category assignments
5024: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
5025: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
5026: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
5027: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged
5028: WHERE mici_merged.ITEM_NUMBER = mici.ITEM_NUMBER
5029: AND mici_merged.ORGANIZATION_ID = mici.ORGANIZATION_ID
5030: AND mici_merged.CATEGORY_SET_NAME = mici.CATEGORY_SET_NAME
5031: AND mici_merged.CATEGORY_NAME = mici.CATEGORY_NAME

Line 6573: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

6569: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6570: ORGANIZATION_ID IS NULL;
6571:
6572:
6573: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6574: SET ORGANIZATION_ID =
6575: CASE
6576: WHEN ORGANIZATION_CODE IS NOT NULL
6577: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MICI.ORGANIZATION_CODE)

Line 6776: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

6772: AND PROCESS_FLAG = 1
6773: AND ITEM_NUMBER IS NULL
6774: AND INVENTORY_ITEM_ID IS NOT NULL;
6775:
6776: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6777: SET item_number = (SELECT CONCATENATED_SEGMENTS
6778: FROM MTL_SYSTEM_ITEMS_KFV
6779: WHERE INVENTORY_ITEM_ID = MICI.INVENTORY_ITEM_ID
6780: AND ORGANIZATION_ID = MICI.ORGANIZATION_ID)

Line 6937: --R12C: Insertion of Fake row into MSII for a orphan row in MTL_ITEM_CATEGORIES_INTERFACE

6933: )
6934: GROUP BY EIAI.ITEM_NUMBER, EIAI.organization_id;
6935: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for ASSOCIATIONS: ' || SQL%ROWCOUNT );
6936:
6937: --R12C: Insertion of Fake row into MSII for a orphan row in MTL_ITEM_CATEGORIES_INTERFACE
6938: INSERT INTO
6939: MTL_SYSTEM_ITEMS_INTERFACE MSII
6940: ( transaction_type, process_flag, set_process_id, organization_id, source_system_id
6941: , confirm_status, inventory_item_id, item_number

Line 6952: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

6948: , l_insert_date -- LAST_UPDATE_DATE
6949: , MAX( MICI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6950: , MAX( MICI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6951: , MAX( MICI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6952: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
6953: WHERE
6954: set_process_id = p_data_set_id
6955: AND process_flag = 1
6956: AND MICI.organization_id = l_org_id

Line 7021: UPDATE MTL_ITEM_CATEGORIES_INTERFACE

7017: SET PROCESS_FLAG = 0
7018: WHERE SET_PROCESS_ID = p_data_set_id AND
7019: PROCESS_FLAG IS NULL;
7020:
7021: UPDATE MTL_ITEM_CATEGORIES_INTERFACE
7022: SET PROCESS_FLAG = 0
7023: WHERE SET_PROCESS_ID = p_data_set_id AND
7024: PROCESS_FLAG IS NULL;
7025:

Line 7192: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

7188: , l_insert_date -- LAST_UPDATE_DATE
7189: , MAX( MICI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
7190: , MAX( MICI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
7191: , MAX( MICI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
7192: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
7193: WHERE
7194: MICI.set_process_id = p_data_set_id
7195: AND MICI.process_flag = 0
7196: AND MICI.organization_id = l_org_id

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 8715: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

8711: AND MSII.ORGANIZATION_ID = l_org_id);
8712:
8713: Debug_Conc_Log('Resolve_Child_Entities - After resolving revision rows' );
8714: -- updating item_number, item_id from MSII table
8715: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
8716: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8717: (SELECT
8718: 1,
8719: (CASE

Line 9144: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

9140: END IF;
9141:
9142: -- updating the item category assignments
9143: l_sql := q'#
9144: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
9145: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9146: (SELECT
9147: 1,
9148: MICI.TRANSACTION_TYPE,

Line 9649: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

9645: );
9646: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9647:
9648: -- updating item category assignments
9649: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
9650: SET PROCESS_FLAG = 1
9651: WHERE ( INVENTORY_ITEM_ID = l_item_id
9652: OR ( ITEM_NUMBER = l_item_number
9653: AND INVENTORY_ITEM_ID IS NULL

Line 9760: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

9756: );
9757: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9758:
9759: -- updating item category assignments
9760: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
9761: SET PROCESS_FLAG = 1
9762: WHERE ITEM_NUMBER = l_item_number
9763: AND PROCESS_FLAG = 3
9764: AND SET_PROCESS_ID = p_batch_id

Line 10020: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

10016: );
10017: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10018:
10019: -- updating item category assignments
10020: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
10021: SET PROCESS_FLAG = 1
10022: WHERE SOURCE_SYSTEM_ID = l_ss_id
10023: AND SOURCE_SYSTEM_REFERENCE = l_ssr
10024: AND PROCESS_FLAG = 3

Line 12675: FROM MTL_ITEM_CATEGORIES_INTERFACE mici

12671: THEN 1
12672: ELSE NULL
12673: END
12674: ) UPDATE_CNT
12675: FROM MTL_ITEM_CATEGORIES_INTERFACE mici
12676: WHERE mici.SET_PROCESS_ID = p_set_process_id
12677: AND EXISTS
12678: (
12679: SELECT NULL