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_RULE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 4843: -- MTL_MATERIAL_TRANSACTIONS_TEMP

4839: -- for a sub-transfer from a non-reservable subinventory.
4840: -- It assumed that pending transactions only exist at locator and lpn level
4841: -- The quantity is calculated with onhand quantity from
4842: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
4843: -- MTL_MATERIAL_TRANSACTIONS_TEMP
4844: -- First get onhand and pending transactions at LPN level
4845: -- If LPN level availability > 0 then get pending transactions at Locator level
4846: -- return onhand less pending transactions
4847: -- NOTES :-

Line 4914: FROM mtl_material_transactions_temp mmtt

4910: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
4911: Sign(mmtt.primary_quantity)))
4912: * round(Abs(mmtt.primary_quantity),5))
4913: INTO l_mmtt_qty_src
4914: FROM mtl_material_transactions_temp mmtt
4915: WHERE mmtt.organization_id = p_organization_id
4916: AND mmtt.inventory_item_id = p_inventory_item_id
4917: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
4918: AND mmtt.subinventory_code = p_subinventory_code

Line 4935: FROM mtl_material_transactions_temp mmtt

4931: END IF;
4932:
4933: SELECT SUM(Abs(mmtt.primary_quantity))
4934: INTO l_mmtt_qty_dest
4935: FROM mtl_material_transactions_temp mmtt
4936: WHERE decode(mmtt.transaction_action_id,3,
4937: mmtt.transfer_organization,mmtt.organization_id) = p_organization_id
4938: AND mmtt.inventory_item_id = p_inventory_item_id
4939: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')

Line 4966: FROM mtl_material_transactions_temp mmtt

4962: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
4963: Sign(mmtt.primary_quantity)))
4964: * round(Abs(mmtt.primary_quantity),5))
4965: INTO l_mmtt_qty_src
4966: FROM mtl_material_transactions_temp mmtt
4967: WHERE mmtt.organization_id = p_organization_id
4968: AND mmtt.inventory_item_id = p_inventory_item_id
4969: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
4970: AND mmtt.subinventory_code = p_subinventory_code

Line 5003: FROM mtl_material_transactions_temp mmtt

4999: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
5000: Sign(mmtt.primary_quantity)))
5001: * round(Abs(mmtt.primary_quantity),5))
5002: INTO l_mmtt_qty_src
5003: FROM mtl_material_transactions_temp mmtt
5004: WHERE mmtt.organization_id = p_organization_id
5005: AND mmtt.inventory_item_id = p_inventory_item_id
5006: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
5007: AND mmtt.subinventory_code = p_subinventory_code

Line 6464: -- MTL_MATERIAL_TRANSACTIONS_TEMP );

6460: -- input parameters and creates recommendations
6461: -- Pre-reqs : Record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
6462: -- identified by parameters p_transaction_temp_id and
6463: -- p_type_code ( base table for the view is
6464: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
6465: -- At least one transaction detail record in
6466: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
6467: -- and parameters p_transaction_temp_id and p_type_code
6468: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 6468: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

6464: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
6465: -- At least one transaction detail record in
6466: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
6467: -- and parameters p_transaction_temp_id and p_type_code
6468: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
6469: -- WMS_TRANSACTIONS_TEMP, respectively );
6470: -- Rule record has to exist in WMS_RULES_B uniquely
6471: -- identified by parameter p_rule_id;
6472: -- Package WMS_RULE_(RULEID) must exist;

Line 12814: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')

12810: ELSIF (l_type_code = 7) THEN
12811: -- Generate package for Operation Plan Rules
12812: g_stmt := 'select count(*) '
12813: || ' from '
12814: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')
12815: || ' where mmtt.transaction_temp_id = p_pp_transaction_temp_id '
12816: || g_rule_where;
12817: --assemble create package statement
12818: l_pack_sql :=

Line 12878: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')

12874: ELSIF (l_type_code = 3) THEN
12875: -- Generate package for Task Type Rules
12876: g_stmt := 'select count(*) '
12877: || ' from '
12878: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')
12879: || ' where nvl(mmtt.parent_line_id,mmtt.transaction_temp_id) = p_pp_transaction_temp_id ' -- Bug Fix 5560849
12880: || g_rule_where;
12881: --assemble create package statement
12882: l_pack_sql :=

Line 13763: -- This procedure loops through mtl_material_transactions_temp table, assign

13759: -- Current version 1.0
13760: --
13761: -- Notes : calls Assign_operation_plan(p_task_id NUMBER)
13762: --
13763: -- This procedure loops through mtl_material_transactions_temp table, assign
13764: -- user defined operation plans to tasks that have not been assigned a operation_plan
13765: -- for the given Move Order Header.
13766: --
13767:

Line 13781: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

13777: , p_move_order_header_id IN NUMBER
13778: ) IS
13779: CURSOR c_tasks IS
13780: SELECT mmtt.transaction_temp_id
13781: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
13782: WHERE mmtt.operation_plan_id IS NULL
13783: AND mmtt.move_order_line_id = mol.line_id
13784: AND mol.header_id = p_move_order_header_id;
13785:

Line 13807: FROM mtl_material_transactions_temp mmtt,

13803: WHERE rules.type_code = 7
13804: AND rules.enabled_flag = 'Y'
13805: AND (organization_id = -1
13806: OR organization_id IN (SELECT mmtt.organization_id
13807: FROM mtl_material_transactions_temp mmtt,
13808: mtl_txn_request_lines mol
13809: WHERE mmtt.standard_operation_id IS NULL
13810: AND mmtt.move_order_line_id = mol.line_id
13811: AND mol.header_id = p_move_order_header_id)));

Line 13862: UPDATE mtl_material_transactions_temp mmtt

13858: -- No rules exist for outbound operaton plan selection.
13859: -- Just stamp the org default outbound operation plan or the default
13860: -- "Locator and LPN Based Consolidation in Staging Lane" seeded outbound operation plan
13861: -- for the MMTT records associated with the move order header.
13862: UPDATE mtl_material_transactions_temp mmtt
13863: SET mmtt.operation_plan_id = (SELECT NVL(default_pick_op_plan_id, 1)
13864: FROM mtl_parameters mp
13865: WHERE mp.organization_id = mmtt.organization_id)
13866: WHERE mmtt.operation_plan_id IS NULL

Line 13892: -- mtl_material_transactions_temp. Operation plan is implemeted by WMS rules.

13888: --
13889: -- Notes :
13890: --
13891: -- This procedure assign user defined operation plan to a specific task in
13892: -- mtl_material_transactions_temp. Operation plan is implemeted by WMS rules.
13893: -- This procedure calls the rule package created for operation plan rules to check
13894: -- which operation plan rule actually matches the task in question.
13895:
13896:

Line 13929: FROM wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt

13925: SELECT rules.rule_id
13926: , mmtt.organization_id
13927: , mmtt.wms_task_type
13928: , rules.type_hdr_id
13929: FROM wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt
13930: WHERE rules.type_code = 7
13931: AND rules.enabled_flag = 'Y'
13932: AND rules.type_hdr_id = wop.operation_plan_id
13933: AND wop.system_task_type = NVL(mmtt.wms_task_type, wop.system_task_type)

Line 14011: UPDATE mtl_material_transactions_temp mmtt

14007:
14008: -- update mmtt table to assign the operation plan
14009:
14010:
14011: UPDATE mtl_material_transactions_temp mmtt
14012: SET mmtt.operation_plan_id = l_operation_plan_id
14013: WHERE mmtt.transaction_temp_id = p_task_id;
14014:
14015: EXIT; -- operation plan assigned, jump out of the rule loop

Line 14033: from mtl_material_transactions_temp

14029:
14030: begin
14031: select organization_id
14032: into l_organization_id
14033: from mtl_material_transactions_temp
14034: where transaction_temp_id = p_task_id
14035: AND transaction_source_type_id IN (2, 8); -- bug fix 3361560
14036: exception
14037: when others then

Line 14055: UPDATE mtl_material_transactions_temp mmtt

14051: END IF;
14052:
14053: l_operation_plan_id := g_default_operation_plan_id;
14054:
14055: UPDATE mtl_material_transactions_temp mmtt
14056: SET mmtt.operation_plan_id = l_operation_plan_id
14057: WHERE mmtt.transaction_temp_id = p_task_id;
14058: END IF;
14059:

Line 14106: -- This procedure loops through mtl_material_transactions_temp table, assign

14102: -- Current version 1.0
14103: --
14104: -- Notes : calls AssignTTs(p_task_id NUMBER)
14105: --
14106: -- This procedure loops through mtl_material_transactions_temp table, assign
14107: -- user defined task type to tasks that have not been assigned a task type
14108: -- for the given Move Order Header.
14109: --
14110:

Line 14126: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

14122: CURSOR c_tasks IS
14123: SELECT mmtt.transaction_temp_id
14124: ,mmtt.organization_id -- Added new
14125: ,mmtt.wms_task_type -- Added new
14126: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
14127: WHERE mmtt.standard_operation_id IS NULL
14128: AND mmtt.move_order_line_id = mol.line_id
14129: AND mol.header_id = p_move_order_header_id;
14130:

Line 14155: FROM mtl_material_transactions_temp mmtt,

14151: WHERE rules.type_code = 3
14152: AND rules.enabled_flag = 'Y'
14153: AND (organization_id = -1
14154: OR organization_id IN (SELECT mmtt.organization_id
14155: FROM mtl_material_transactions_temp mmtt,
14156: mtl_txn_request_lines mol
14157: WHERE mmtt.standard_operation_id IS NULL
14158: AND mmtt.move_order_line_id = mol.line_id
14159: AND mol.header_id = p_move_order_header_id)));

Line 14193: UPDATE mtl_material_transactions_temp mmtt

14189: ELSE
14190: -- Bug# 4587423
14191: -- No valid rules exist for task type assignment so just stamp the org level
14192: -- default task type for the given WMS task type on the MMTT record.
14193: UPDATE mtl_material_transactions_temp mmtt
14194: SET standard_operation_id =
14195: (SELECT DECODE(mmtt.wms_task_type, 1, default_pick_task_type_id,
14196: 2, default_putaway_task_type_id,
14197: 3, default_cc_task_type_id,

Line 14228: -- mtl_material_transactions_temp. Task type is implemeted by WMS rules.

14224: --
14225: -- Notes :
14226: --
14227: -- This procedure assign user defined task types to a specific task in
14228: -- mtl_material_transactions_temp. Task type is implemeted by WMS rules.
14229: -- This procedure calls the rule package created for task type rules to check
14230: -- which task type rule actually matches the task in question.
14231: --
14232:

Line 14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt

14278: SELECT rules.rule_id
14279: , rules.type_hdr_id /* Added this Column */
14280: , mmtt.organization_id
14281: , mmtt.wms_task_type
14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
14283: WHERE rules.type_code = 3
14284: AND rules.enabled_flag = 'Y'
14285: AND rules.type_hdr_id = bso.standard_operation_id
14286: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)

Line 14405: UPDATE mtl_material_transactions_temp mmtt

14401: l_found := TRUE;
14402:
14403: -- update mmtt table to assign the task type
14404:
14405: UPDATE mtl_material_transactions_temp mmtt
14406: SET mmtt.standard_operation_id = l_type_hdr_id
14407: WHERE mmtt.transaction_temp_id = p_task_id;
14408: /*
14409: UPDATE mtl_material_transactions_temp mmtt

Line 14409: UPDATE mtl_material_transactions_temp mmtt

14405: UPDATE mtl_material_transactions_temp mmtt
14406: SET mmtt.standard_operation_id = l_type_hdr_id
14407: WHERE mmtt.transaction_temp_id = p_task_id;
14408: /*
14409: UPDATE mtl_material_transactions_temp mmtt
14410: SET mmtt.standard_operation_id = (SELECT type_hdr_id
14411: FROM wms_rules_b
14412: WHERE rule_id = l_rule_id)
14413: WHERE mmtt.transaction_temp_id = p_task_id

Line 14434: from mtl_material_transactions_temp

14430: -- bug 2737846
14431: begin
14432: select organization_id, wms_task_type
14433: into l_organization_id, l_wms_task_type
14434: from mtl_material_transactions_temp
14435: where transaction_temp_id = p_task_id;
14436: exception
14437: when others then
14438: null;

Line 14498: UPDATE mtl_material_transactions_temp mmtt

14494:
14495: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
14496: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
14497:
14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id
14500: WHERE mmtt.transaction_temp_id = p_task_id;
14501:
14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);

Line 15652: -- MTL_MATERIAL_TRANSACTIONS_TEMP );

15648: -- input parameters and creates recommendations
15649: -- Pre-reqs : Record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
15650: -- identified by parameters p_transaction_temp_id and
15651: -- p_type_code ( base table for the view is
15652: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
15653: -- At least one transaction detail record in
15654: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
15655: -- and parameters p_transaction_temp_id and p_type_code
15656: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 15656: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

15652: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
15653: -- At least one transaction detail record in
15654: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
15655: -- and parameters p_transaction_temp_id and p_type_code
15656: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
15657: -- WMS_TRANSACTIONS_TEMP, respectively );
15658: -- Rule record has to exist in WMS_RULES_B uniquely
15659: -- identified by parameter p_rule_id;
15660: -- Package WMS_RULE_(RULEID) must exist;