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 613: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI ';

609: l_dyn_sql := l_dyn_sql || ' AND PROCESS_FLAG = :PROCESS_STATUS_2 ';
610: l_dyn_sql := l_dyn_sql || ' ) ';
611: l_dyn_sql := l_dyn_sql || ' OR EXISTS( ';
612: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
613: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI ';
614: l_dyn_sql := l_dyn_sql || ' WHERE MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID ';
615: l_dyn_sql := l_dyn_sql || ' AND MSII.ORGANIZATION_ID = MSI.ORGANIZATION_ID ';
616: l_dyn_sql := l_dyn_sql || ' ) ';-- End Bug 3763665
617: l_dyn_sql := l_dyn_sql || ' ) ';

Line 1209: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

1205: l_tracking_qty_ind_col VARCHAR2(50);
1206: --Bug: 3969593 End
1207:
1208: l_catalog_group_id VARCHAR2(50);
1209: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
1210:
1211: l_msii_set_process_id NUMBER;
1212: i NUMBER;
1213: l_cursor_select INTEGER;

Line 1583: FROM MTL_SYSTEM_ITEMS_B

1579: l_inventory_item_id := FND_FLEX_KEYVAL.combination_id;
1580:
1581: --Start bug:15930715
1582: Select ITEM_CATALOG_GROUP_ID into l_catalog_group_id
1583: FROM MTL_SYSTEM_ITEMS_B
1584: WHERE INVENTORY_ITEM_ID=l_inventory_item_id
1585: AND ORGANIZATION_ID=l_org_id_table(i);
1586:
1587: -- fix bug: 14307504

Line 3152: -- FROM MTL_SYSTEM_ITEMS_B MSI

3148: -- AND PROCESS_FLAG = G_PROCESS_STATUS
3149: -- )
3150: -- OR EXISTS(
3151: -- SELECT 'X'
3152: -- FROM MTL_SYSTEM_ITEMS_B MSI
3153: -- WHERE MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
3154: -- AND MSII.ORGANIZATION_ID = MSI.ORGANIZATION_ID
3155: -- )-- End Bug 3763665
3156: -- );

Line 3455: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

3451: l_org_code_col VARCHAR2(30);
3452: l_rev_code_col VARCHAR2(30);
3453: l_lifecycle_col_val VARCHAR2(50);
3454: l_lifecycle_phase_col_val VARCHAR2(50);
3455: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
3456: l_item_catalog_name_col VARCHAR2(50);
3457:
3458: l_msii_set_process_id NUMBER;
3459: i NUMBER;

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

3993: ----------------------------------------------------------------------------------
3994: -- Fix for Bug:3624686
3995: -- As a part of 11.5.10, Setting the Lifecycle for Revision is not available.
3996: -- But setting Lifecycle Phase is still possible.
3997: -- Hence pick up the Lifecycle from Item (MTL_SYSTEM_ITEMS_B) and set in
3998: -- MTL_ITEM_REVISIONS_INTERFACE.
3999: ----------------------------------------------------------------------------------
4000:
4001: ----------------------------------------------------------------------------------

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

4006: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
4007: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
4008: l_dyn_sql := l_dyn_sql || '( ';
4009: l_dyn_sql := l_dyn_sql || ' SELECT MSI.LIFECYCLE_ID ';
4010: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';
4011: l_dyn_sql := l_dyn_sql || ' WHERE MSI.INVENTORY_ITEM_ID = EBI.INSTANCE_PK1_VALUE ';
4012: l_dyn_sql := l_dyn_sql || ' AND MSI.ORGANIZATION_ID = EBI.INSTANCE_PK2_VALUE ';
4013: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
4014: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MIRI.TRANSACTION_ID ';

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

4016: l_dyn_sql := l_dyn_sql || ') ';
4017: l_dyn_sql := l_dyn_sql || ' WHERE EXISTS ';
4018: l_dyn_sql := l_dyn_sql || '( ';
4019: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
4020: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';
4021: l_dyn_sql := l_dyn_sql || ' WHERE MSI.INVENTORY_ITEM_ID = EBI.INSTANCE_PK1_VALUE ';
4022: l_dyn_sql := l_dyn_sql || ' AND MSI.ORGANIZATION_ID = EBI.INSTANCE_PK2_VALUE ';
4023: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
4024: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MIRI.TRANSACTION_ID ';

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

4029: l_dyn_sql := l_dyn_sql || ') ';
4030:
4031: Write_Debug(l_dyn_sql);
4032: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id, p_resultfmt_usage_id;
4033: Write_Debug('MIRI: Updated the Lifecycle IDs from MTL_SYSTEM_ITEMS_B.');
4034:
4035: ----------------------------------------------------------------------------------
4036: -- Next Transfer the Lifecycle Phase information from EBI to MSII
4037: -- by doing Value-to-ID Conversion, and by joining Lifecycle ID information.

Line 6097: ' UPDATE MTL_SYSTEM_ITEMS_B MSIB ' ||

6093: Write_Debug('POST-PROCESSING After IOI + User-Def + UCCnet Attts processing');
6094: Write_Debug('-----------------------------------------------------------------');
6095:
6096: l_dyn_sql :=
6097: ' UPDATE MTL_SYSTEM_ITEMS_B MSIB ' ||
6098: ' SET (MSIB.UNIT_WEIGHT, MSIB.WEIGHT_UOM_CODE) = ' ||
6099: ' ( ' ||
6100: ' DECODE(MSIB.TRADE_ITEM_DESCRIPTOR, ''BASE_UNIT_OR_EACH'', MSIB.UNIT_WEIGHT, NULL), ' ||
6101: ' DECODE(MSIB.TRADE_ITEM_DESCRIPTOR, ''BASE_UNIT_OR_EACH'', MSIB.WEIGHT_UOM_CODE, NULL) ' ||

Line 6671: FROM MTL_SYSTEM_ITEMS_B

6667: l_tradeItemDescriptor VARCHAR2(100);
6668: BEGIN
6669:
6670: SELECT TRADE_ITEM_DESCRIPTOR INTO x_tradeItemDescriptor
6671: FROM MTL_SYSTEM_ITEMS_B
6672: WHERE INVENTORY_ITEM_ID = to_number(p_inventory_item_id)
6673: AND ORGANIZATION_ID = to_number(p_organization_id);
6674:
6675:

Line 6713: FROM MTL_SYSTEM_ITEMS_B

6709: AND PROCESS_STATUS = 7;
6710:
6711: CURSOR c_gtid (c_inventory_itemId IN NUMBER , c_organization_Id IN NUMBER) IS
6712: SELECT TRADE_ITEM_DESCRIPTOR
6713: FROM MTL_SYSTEM_ITEMS_B
6714: WHERE INVENTORY_ITEM_ID = c_inventory_itemId
6715: AND ORGANIZATION_ID = c_organization_Id ;
6716:
6717: /* Editable at root