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_UTIL_PVT dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 4061: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi

4057: );
4058:
4059: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated MTL_ITEM_CATEGORIES_INTERFACE rowcount='||SQL%ROWCOUNT);
4060:
4061: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi
4062: SET PROCESS_FLAG = 6,
4063: REQUEST_ID = l_request_id,
4064: PROGRAM_ID = l_prog_id,
4065: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 4083: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);

4079: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID
4080: AND eime.LAST_MESSAGE_TIMESTAMP > msii.MESSAGE_TIMESTAMP
4081: );
4082:
4083: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
4084: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
4085: SET PROCESS_FLAG = 6,
4086: REQUEST_ID = l_request_id,
4087: PROGRAM_ID = l_prog_id,

Line 5997: UPDATE BOM_BILL_OF_MTLS_INTERFACE

5993: AND SOURCE_SYSTEM_ID = p_ss_id
5994: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5995:
5996: -- propagating to BOM tables
5997: UPDATE BOM_BILL_OF_MTLS_INTERFACE
5998: SET ITEM_NUMBER = p_item_number
5999: WHERE PROCESS_FLAG = 1
6000: AND BATCH_ID = p_batch_id
6001: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6655: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi

6651: AND mici.BUNDLE_ID = msii.BUNDLE_ID
6652: );
6653:
6654: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated MTL_ITEM_CATEGORIES_INTERFACE rowcount='||SQL%ROWCOUNT);
6655: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi
6656: SET PROCESS_FLAG = 6,
6657: REQUEST_ID = l_request_id,
6658: PROGRAM_ID = l_prog_id,
6659: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 6673: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);

6669: AND bbmi.ORGANIZATION_ID = msii.ORGANIZATION_ID
6670: AND bbmi.BUNDLE_ID = msii.BUNDLE_ID
6671: );
6672:
6673: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
6674: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
6675: SET PROCESS_FLAG = 6,
6676: REQUEST_ID = l_request_id,
6677: PROGRAM_ID = l_prog_id,

Line 7063: delete FROM BOM_BILL_OF_MTLS_INTERFACE A

7059: and A.process_flag=1
7060: and BATCH_ID=p_batch_id and ALTERNATE_BOM_DESIGNATOR = 'PIM_PBOM_S' and bundle_id = I2.bundle_id;
7061:
7062:
7063: delete FROM BOM_BILL_OF_MTLS_INTERFACE A
7064: WHERE
7065: exists (SELECT 'x' FROM BOM_BILL_OF_MTLS_INTERFACE B
7066: WHERE
7067: B.SOURCE_SYSTEM_REFERENCE = A.SOURCE_SYSTEM_REFERENCE

Line 7065: exists (SELECT 'x' FROM BOM_BILL_OF_MTLS_INTERFACE B

7061:
7062:
7063: delete FROM BOM_BILL_OF_MTLS_INTERFACE A
7064: WHERE
7065: exists (SELECT 'x' FROM BOM_BILL_OF_MTLS_INTERFACE B
7066: WHERE
7067: B.SOURCE_SYSTEM_REFERENCE = A.SOURCE_SYSTEM_REFERENCE
7068: and B.PROCESS_FLAG = A.PROCESS_FLAG
7069: and B.batch_id = A.batch_id -- fix for bug#9132730