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_ITEM_BULKLOAD_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 576: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI ';

572: l_dyn_sql := l_dyn_sql || ' AND PROCESS_FLAG = :PROCESS_STATUS_2 ';
573: l_dyn_sql := l_dyn_sql || ' ) ';
574: l_dyn_sql := l_dyn_sql || ' OR EXISTS( ';
575: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
576: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI ';
577: l_dyn_sql := l_dyn_sql || ' WHERE MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID ';
578: l_dyn_sql := l_dyn_sql || ' AND MSII.ORGANIZATION_ID = MSI.ORGANIZATION_ID ';
579: l_dyn_sql := l_dyn_sql || ' ) ';-- End Bug 3763665
580: l_dyn_sql := l_dyn_sql || ' ) ';

Line 1171: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

1167: l_tracking_qty_ind_col VARCHAR2(50);
1168: --Bug: 3969593 End
1169:
1170: l_catalog_group_id VARCHAR2(50);
1171: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
1172:
1173: l_msii_set_process_id NUMBER;
1174: i NUMBER;
1175: l_cursor_select INTEGER;

Line 3067: -- FROM MTL_SYSTEM_ITEMS_B MSI

3063: -- AND PROCESS_FLAG = G_PROCESS_STATUS
3064: -- )
3065: -- OR EXISTS(
3066: -- SELECT 'X'
3067: -- FROM MTL_SYSTEM_ITEMS_B MSI
3068: -- WHERE MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
3069: -- AND MSII.ORGANIZATION_ID = MSI.ORGANIZATION_ID
3070: -- )-- End Bug 3763665
3071: -- );

Line 3370: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

3366: l_org_code_col VARCHAR2(30);
3367: l_rev_code_col VARCHAR2(30);
3368: l_lifecycle_col_val VARCHAR2(50);
3369: l_lifecycle_phase_col_val VARCHAR2(50);
3370: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
3371: l_item_catalog_name_col VARCHAR2(50);
3372:
3373: l_msii_set_process_id NUMBER;
3374: i NUMBER;

Line 3912: -- Hence pick up the Lifecycle from Item (MTL_SYSTEM_ITEMS_B) and set in

3908: ----------------------------------------------------------------------------------
3909: -- Fix for Bug:3624686
3910: -- As a part of 11.5.10, Setting the Lifecycle for Revision is not available.
3911: -- But setting Lifecycle Phase is still possible.
3912: -- Hence pick up the Lifecycle from Item (MTL_SYSTEM_ITEMS_B) and set in
3913: -- MTL_ITEM_REVISIONS_INTERFACE.
3914: ----------------------------------------------------------------------------------
3915:
3916: ----------------------------------------------------------------------------------

Line 3925: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';

3921: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3922: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
3923: l_dyn_sql := l_dyn_sql || '( ';
3924: l_dyn_sql := l_dyn_sql || ' SELECT MSI.LIFECYCLE_ID ';
3925: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';
3926: l_dyn_sql := l_dyn_sql || ' WHERE MSI.INVENTORY_ITEM_ID = EBI.INSTANCE_PK1_VALUE ';
3927: l_dyn_sql := l_dyn_sql || ' AND MSI.ORGANIZATION_ID = EBI.INSTANCE_PK2_VALUE ';
3928: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
3929: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MIRI.TRANSACTION_ID ';

Line 3935: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';

3931: l_dyn_sql := l_dyn_sql || ') ';
3932: l_dyn_sql := l_dyn_sql || ' WHERE EXISTS ';
3933: l_dyn_sql := l_dyn_sql || '( ';
3934: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
3935: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';
3936: l_dyn_sql := l_dyn_sql || ' WHERE MSI.INVENTORY_ITEM_ID = EBI.INSTANCE_PK1_VALUE ';
3937: l_dyn_sql := l_dyn_sql || ' AND MSI.ORGANIZATION_ID = EBI.INSTANCE_PK2_VALUE ';
3938: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
3939: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MIRI.TRANSACTION_ID ';

Line 3948: Write_Debug('MIRI: Updated the Lifecycle IDs from MTL_SYSTEM_ITEMS_B.');

3944: l_dyn_sql := l_dyn_sql || ') ';
3945:
3946: Write_Debug(l_dyn_sql);
3947: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
3948: Write_Debug('MIRI: Updated the Lifecycle IDs from MTL_SYSTEM_ITEMS_B.');
3949:
3950: ----------------------------------------------------------------------------------
3951: -- Next Transfer the Lifecycle Phase information from EBI to MSII
3952: -- by doing Value-to-ID Conversion, and by joining Lifecycle ID information.

Line 5944: ' UPDATE MTL_SYSTEM_ITEMS_B MSIB ' ||

5940: Write_Debug('POST-PROCESSING After IOI + User-Def + UCCnet Attts processing');
5941: Write_Debug('-----------------------------------------------------------------');
5942:
5943: l_dyn_sql :=
5944: ' UPDATE MTL_SYSTEM_ITEMS_B MSIB ' ||
5945: ' SET (MSIB.UNIT_WEIGHT, MSIB.WEIGHT_UOM_CODE) = ' ||
5946: ' ( ' ||
5947: ' DECODE(MSIB.TRADE_ITEM_DESCRIPTOR, ''BASE_UNIT_OR_EACH'', MSIB.UNIT_WEIGHT, NULL), ' ||
5948: ' DECODE(MSIB.TRADE_ITEM_DESCRIPTOR, ''BASE_UNIT_OR_EACH'', MSIB.WEIGHT_UOM_CODE, NULL) ' ||

Line 6518: FROM MTL_SYSTEM_ITEMS_B

6514: l_tradeItemDescriptor VARCHAR2(100);
6515: BEGIN
6516:
6517: SELECT TRADE_ITEM_DESCRIPTOR INTO x_tradeItemDescriptor
6518: FROM MTL_SYSTEM_ITEMS_B
6519: WHERE INVENTORY_ITEM_ID = to_number(p_inventory_item_id)
6520: AND ORGANIZATION_ID = to_number(p_organization_id);
6521:
6522:

Line 6560: FROM MTL_SYSTEM_ITEMS_B

6556: AND PROCESS_STATUS = 7;
6557:
6558: CURSOR c_gtid (c_inventory_itemId IN NUMBER , c_organization_Id IN NUMBER) IS
6559: SELECT TRADE_ITEM_DESCRIPTOR
6560: FROM MTL_SYSTEM_ITEMS_B
6561: WHERE INVENTORY_ITEM_ID = c_inventory_itemId
6562: AND ORGANIZATION_ID = c_organization_Id ;
6563:
6564: /* Editable at root