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 895: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )

891: -- customer-defined manner before actually following his own
892: -- algorithm to determine the valid strategy.
893: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
894: -- identified by parameters p_transaction_temp_id and
895: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
896: -- Parameters :
897: -- p_api_version in number required
898: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
899: -- p_validation_level in number optional default =

Line 1679: FROM mtl_material_transactions_temp

1675: SELECT NVL(SUM(transaction_quantity), 0)
1676: , NVL(SUM(secondary_transaction_quantity), 0)
1677: INTO l_other_alloc
1678: , l_other_sec_alloc
1679: FROM mtl_material_transactions_temp
1680: WHERE move_order_line_id <> p_transaction_temp_id
1681: AND organization_id = p_organization_id
1682: AND inventory_item_id = p_inventory_item_id
1683: AND transaction_action_id = 28

Line 1705: FROM mtl_material_transactions_temp mmtt

1701: SELECT NVL(SUM(transaction_quantity), 0)
1702: , NVL(SUM(secondary_transaction_quantity), 0)
1703: INTO l_alloc_qty
1704: , l_alloc_sec_qty
1705: FROM mtl_material_transactions_temp mmtt
1706: WHERE mmtt.organization_id = p_organization_id
1707: AND mmtt.inventory_item_id = p_inventory_item_id
1708: AND mmtt.transaction_action_id = 28
1709: AND mmtt.trx_source_line_id IN

Line 1728: AND EXISTS (SELECT 1 FROM mtl_material_transactions_temp

1724: AND wdd.source_line_id <> p_trx_source_line_id
1725: AND wdd.source_code = 'OE'
1726: AND wdd.container_flag = 'N'
1727: AND wdd.source_header_id =l_source_header_id
1728: AND EXISTS (SELECT 1 FROM mtl_material_transactions_temp
1729: WHERE wdd.source_line_id = trx_source_line_id) ;
1730:
1731: IF (l_debug = 1) THEN
1732: log_statement(l_api_name, 'l_alloc_qty', l_alloc_qty);

Line 1790: FROM mtl_material_transactions_temp

1786: SELECT NVL(SUM(transaction_quantity), 0)
1787: , NVL(SUM(secondary_transaction_quantity), 0)
1788: INTO l_cur_mo_alloc
1789: , l_cur_mo_sec_alloc
1790: FROM mtl_material_transactions_temp
1791: WHERE move_order_line_id = p_transaction_temp_id;
1792:
1793: -- l_max_possible_qty is maximum quantity(including tolerance) that can be allocated
1794: -- l_other_alloc should never exceed l_max_quantity, however to be safe putting GREATEST

Line 1866: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )

1862: -- Function : Applies a pick or put away strategy to the given transaction
1863: -- or reservation input parameters and creates recommendations
1864: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
1865: -- identified by parameters p_transaction_temp_id and
1866: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1867: -- at least one transaction detail record in
1868: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1869: -- and parameters p_transaction_temp_id and p_type_code
1870: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 1870: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and

1866: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1867: -- at least one transaction detail record in
1868: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1869: -- and parameters p_transaction_temp_id and p_type_code
1870: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1871: -- WMS_TRANSACTIONS_TEMP )
1872: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1873: -- parameter p_strategy_id
1874: -- at least one strategy member record in

Line 1941: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;

1937: -- API standard variables
1938: l_api_version constant number := 1.0;
1939: l_api_name constant varchar2(30) := 'Apply';
1940:
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;

Line 1942: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;

1938: l_api_version constant number := 1.0;
1939: l_api_name constant varchar2(30) := 'Apply';
1940:
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;

Line 1944: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;

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

Line 1949: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%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
1951: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1952: l_trx_source_line_id
1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;

Line 1951: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%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
1951: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1952: l_trx_source_line_id
1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1954: l_trx_source_delivery_id
1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;

Line 1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;

1949: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%type;
1950: l_transaction_source_id
1951: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1952: l_trx_source_line_id
1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1954: l_trx_source_delivery_id
1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1956: l_transaction_source_name
1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;

Line 1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;

1951: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%type;
1952: l_trx_source_line_id
1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1954: l_trx_source_delivery_id
1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1956: l_transaction_source_name
1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1958: l_transaction_type_id
1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;

Line 1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;

1953: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%type;
1954: l_trx_source_delivery_id
1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1956: l_transaction_source_name
1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1958: l_transaction_type_id
1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1960:
1961: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;

Line 1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;

1955: MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%type;
1956: l_transaction_source_name
1957: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%type;
1958: l_transaction_type_id
1959: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%type;
1960:
1961: l_rule_id WMS_STRATEGY_MEMBERS.RULE_ID%type;
1962: l_partial_success_allowed_flag
1963: WMS_STRATEGY_MEMBERS.PARTIAL_SUCCESS_ALLOWED_FLAG%type;

Line 1975: l_req_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%type;

1971: l_allow_non_partial_rules BOOLEAN;
1972:
1973: --Aded bug3237702 caching
1974: l_req_locator_id NUMBER;
1975: l_req_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%type;
1976: is_pickrelease BOOLEAN;
1977: --Bug 3237702 ends
1978:
1979: -- Rules J Project Variables

Line 2376: FROM mtl_material_transactions_temp mmtt

2372: AND mtrl.organization_id = l_organization_id
2373: AND mtrl.line_status in (3,7) --11711464
2374: HAVING SUM(mtrl.secondary_quantity - NVL(mtrl.secondary_quantity_delivered, 0))
2375: < (SELECT SUM(NVL(mmtt.secondary_transaction_quantity, 0))
2376: FROM mtl_material_transactions_temp mmtt
2377: WHERE mmtt.trx_source_line_id = l_trx_source_line_id
2378: AND mmtt.move_order_line_id <> p_transaction_temp_id
2379: AND mmtt.inventory_item_id = l_inventory_item_id
2380: AND mmtt.organization_id = l_organization_id

Line 2395: FROM mtl_material_transactions_temp mmtt

2391: AND mtrl.organization_id = l_organization_id
2392: AND mtrl.line_status in (3,7) --11711464
2393: HAVING SUM(mtrl.quantity - NVL(mtrl.quantity_delivered, 0))
2394: < (SELECT SUM(NVL(mmtt.transaction_quantity, 0))
2395: FROM mtl_material_transactions_temp mmtt
2396: WHERE mmtt.trx_source_line_id = l_trx_source_line_id
2397: AND mmtt.move_order_line_id <> p_transaction_temp_id
2398: AND mmtt.inventory_item_id = l_inventory_item_id
2399: AND mmtt.organization_id = l_organization_id