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 667: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;

663: ,x_tree_id out nocopy number
664: ) is
665:
666: l_api_name VARCHAR2(30) := 'InitQtyTree';
667: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
668: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
669: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
670: l_is_revision_control boolean;
671: l_is_lot_control boolean;

Line 668: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;

664: ) is
665:
666: l_api_name VARCHAR2(30) := 'InitQtyTree';
667: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
668: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
669: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
670: l_is_revision_control boolean;
671: l_is_lot_control boolean;
672: l_is_serial_control boolean;

Line 669: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;

665:
666: l_api_name VARCHAR2(30) := 'InitQtyTree';
667: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
668: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
669: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
670: l_is_revision_control boolean;
671: l_is_lot_control boolean;
672: l_is_serial_control boolean;
673: l_msg_data VARCHAR2(240);

Line 681: from MTL_SYSTEM_ITEMS msi

677: cursor iteminfo is
678: select nvl(msi.REVISION_QTY_CONTROL_CODE,1)
679: ,nvl(msi.LOT_CONTROL_CODE,1)
680: ,nvl(msi.SERIAL_NUMBER_CONTROL_CODE,1)
681: from MTL_SYSTEM_ITEMS msi
682: where ORGANIZATION_ID = p_organization_id
683: and INVENTORY_ITEM_ID = p_inventory_item_id
684: ;
685: begin

Line 1789: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;

1785: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;
1786: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1787: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1788: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1789: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1790: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1791: l_grade_code VARCHAR2(150);
1792: l_transaction_source_type_id
1793: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;

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

1786: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1787: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1788: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1789: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1790: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1791: l_grade_code VARCHAR2(150);
1792: l_transaction_source_type_id
1793: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;
1794: l_transaction_source_id