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.WMS_STRATEGY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 199: from mtl_system_items msi

195: ,mpsmttv.transaction_type_id
196: ,mpsmttv.transaction_uom
197: ,msi.primary_uom_code
198: ,msi.secondary_uom_code
199: from mtl_system_items msi
200: ,wms_strategy_mat_txn_tmp_v mpsmttv
201: where msi.organization_id =
202: decode(p_type_code, 1, mpsmttv.to_organization_id,
203: mpsmttv.from_organization_id)

Line 692: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;

688: ,x_tree_id out nocopy number
689: ) is
690:
691: l_api_name VARCHAR2(30) := 'InitQtyTree';
692: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
693: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
694: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
695: l_is_revision_control boolean;
696: l_is_lot_control boolean;

Line 693: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;

689: ) is
690:
691: l_api_name VARCHAR2(30) := 'InitQtyTree';
692: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
693: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
694: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
695: l_is_revision_control boolean;
696: l_is_lot_control boolean;
697: l_is_serial_control boolean;

Line 694: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;

690:
691: l_api_name VARCHAR2(30) := 'InitQtyTree';
692: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
693: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
694: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
695: l_is_revision_control boolean;
696: l_is_lot_control boolean;
697: l_is_serial_control boolean;
698: l_msg_data VARCHAR2(240);

Line 707: from MTL_SYSTEM_ITEMS msi

703: cursor iteminfo is
704: select nvl(msi.REVISION_QTY_CONTROL_CODE,1)
705: ,nvl(msi.LOT_CONTROL_CODE,1)
706: ,nvl(msi.SERIAL_NUMBER_CONTROL_CODE,1)
707: from MTL_SYSTEM_ITEMS msi
708: where ORGANIZATION_ID = p_organization_id
709: and INVENTORY_ITEM_ID = p_inventory_item_id
710: ;
711: begin

Line 1945: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;

1941: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;
1942: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1943: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1944: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1945: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1946: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1947: l_grade_code VARCHAR2(150);
1948: l_transaction_source_type_id
1949: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;

Line 1946: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;

1942: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1943: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1944: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1945: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1946: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1947: l_grade_code VARCHAR2(150);
1948: l_transaction_source_type_id
1949: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;
1950: l_transaction_source_id