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_MATERIAL_TRANSACTIONS_TEMP

Line 857: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )

853: -- customer-defined manner before actually following his own
854: -- algorithm to determine the valid strategy.
855: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
856: -- identified by parameters p_transaction_temp_id and
857: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
858: -- Parameters :
859: -- p_api_version in number required
860: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
861: -- p_validation_level in number optional default =

Line 1623: FROM mtl_material_transactions_temp

1619:
1620: -- l_other_alloc is sum of allocation for all MO except current MO, with same p_trx_source_line_id
1621: SELECT NVL(SUM(transaction_quantity), 0)
1622: INTO l_other_alloc
1623: FROM mtl_material_transactions_temp
1624: WHERE move_order_line_id <> p_transaction_temp_id
1625: AND organization_id = p_organization_id
1626: AND inventory_item_id = p_inventory_item_id
1627: AND transaction_action_id = 28

Line 1659: FROM mtl_material_transactions_temp

1655:
1656: -- l_cur_mo_alloc is any existing allocation for the current MO
1657: SELECT NVL(SUM(transaction_quantity), 0)
1658: INTO l_cur_mo_alloc
1659: FROM mtl_material_transactions_temp
1660: WHERE move_order_line_id = p_transaction_temp_id;
1661:
1662: -- l_max_possible_qty is maximum quantity(including tolerance) that can be allocated
1663: -- l_other_alloc should never exceed l_max_quantity, however to be safe putting GREATEST

Line 1711: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )

1707: -- Function : Applies a pick or put away strategy to the given transaction
1708: -- or reservation input parameters and creates recommendations
1709: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
1710: -- identified by parameters p_transaction_temp_id and
1711: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1712: -- at least one transaction detail record in
1713: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1714: -- and parameters p_transaction_temp_id and p_type_code
1715: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 1715: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and

1711: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1712: -- at least one transaction detail record in
1713: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1714: -- and parameters p_transaction_temp_id and p_type_code
1715: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1716: -- WMS_TRANSACTIONS_TEMP )
1717: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1718: -- parameter p_strategy_id
1719: -- at least one strategy member record in

Line 1785: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;

1781: -- API standard variables
1782: l_api_version constant number := 1.0;
1783: l_api_name constant varchar2(30) := 'Apply';
1784:
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;

Line 1786: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;

1782: l_api_version constant number := 1.0;
1783: l_api_name constant varchar2(30) := 'Apply';
1784:
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;

Line 1788: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;

1784:
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

Line 1793: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%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
1795: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1796: l_trx_source_line_id
1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;

Line 1795: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%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
1795: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1796: l_trx_source_line_id
1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1798: l_trx_source_delivery_id
1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;

Line 1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;

1793: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;
1794: l_transaction_source_id
1795: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1796: l_trx_source_line_id
1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1798: l_trx_source_delivery_id
1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1800: l_transaction_source_name
1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;

Line 1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;

1795: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1796: l_trx_source_line_id
1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1798: l_trx_source_delivery_id
1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1800: l_transaction_source_name
1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1802: l_transaction_type_id
1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;

Line 1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;

1797: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1798: l_trx_source_delivery_id
1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1800: l_transaction_source_name
1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1802: l_transaction_type_id
1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1804:
1805: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

Line 1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;

1799: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1800: l_transaction_source_name
1801: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1802: l_transaction_type_id
1803: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1804:
1805: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1806: l_partial_success_allowed_flag
1807: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

Line 1819: l_req_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%type;

1815: l_allow_non_partial_rules BOOLEAN;
1816:
1817: --Aded bug3237702 caching
1818: l_req_locator_id NUMBER;
1819: l_req_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%type;
1820: is_pickrelease BOOLEAN;
1821: --Bug 3237702 ends
1822:
1823: -- Rules J Project Variables

Line 2180: FROM mtl_material_transactions_temp mmtt

2176: AND mtrl.quantity_detailed IS NOT NULL
2177: AND mtrl.inventory_item_id = l_inventory_item_id
2178: AND mtrl.organization_id = l_organization_id
2179: HAVING sum(mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) < (SELECT sum(Nvl(mmtt.transaction_quantity, 0))
2180: FROM mtl_material_transactions_temp mmtt
2181: WHERE mmtt.trx_source_line_id = l_trx_source_line_id
2182: AND mmtt.move_order_line_id <> p_transaction_temp_id
2183: AND mmtt.inventory_item_id = l_inventory_item_id
2184: AND mmtt.organization_id = l_organization_id