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 2276: --- USE outer join for mtl_transaction_lots_temp and mtl_material_transactions_temp table

2272: l_outer_join := ' (+)';
2273: END IF;
2274: ELSIF l_context_dependent_flag = 'N' THEN
2275: --- Bug# 6893143
2276: --- USE outer join for mtl_transaction_lots_temp and mtl_material_transactions_temp table
2277: --- db_object_id = 1029 for mtl_transaction_lots_temp table
2278: --- parent_table_alias = 'mmtt' for mtl_material_transactions_temp table
2279: --- this is valid for task_type assignment
2280: IF ((l_db_object_id = 1029) AND (UPPER(l_parent_table_alias) = 'MMTT')

Line 2278: --- parent_table_alias = 'mmtt' for mtl_material_transactions_temp table

2274: ELSIF l_context_dependent_flag = 'N' THEN
2275: --- Bug# 6893143
2276: --- USE outer join for mtl_transaction_lots_temp and mtl_material_transactions_temp table
2277: --- db_object_id = 1029 for mtl_transaction_lots_temp table
2278: --- parent_table_alias = 'mmtt' for mtl_material_transactions_temp table
2279: --- this is valid for task_type assignment
2280: IF ((l_db_object_id = 1029) AND (UPPER(l_parent_table_alias) = 'MMTT')
2281: AND (p_type_code = 3)) THEN
2282: log_statement(l_api_name, 'NN DEBUG', 'Adding outer join between MTLT AND MMTT');

Line 6574: -- MTL_MATERIAL_TRANSACTIONS_TEMP

6570: -- for a sub-transfer from a non-reservable subinventory.
6571: -- It assumed that pending transactions only exist at locator and lpn level
6572: -- The quantity is calculated with onhand quantity from
6573: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
6574: -- MTL_MATERIAL_TRANSACTIONS_TEMP
6575: -- First get onhand and pending transactions at LPN level
6576: -- If LPN level availability > 0 then get pending transactions at Locator level
6577: -- return onhand less pending transactions
6578: -- NOTES :-

Line 6645: FROM mtl_material_transactions_temp mmtt

6641: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
6642: Sign(mmtt.primary_quantity)))
6643: * round(Abs(mmtt.primary_quantity),5))
6644: INTO l_mmtt_qty_src
6645: FROM mtl_material_transactions_temp mmtt
6646: WHERE mmtt.organization_id = p_organization_id
6647: AND mmtt.inventory_item_id = p_inventory_item_id
6648: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
6649: AND mmtt.subinventory_code = p_subinventory_code

Line 6666: FROM mtl_material_transactions_temp mmtt

6662: END IF;
6663:
6664: SELECT SUM(Abs(mmtt.primary_quantity))
6665: INTO l_mmtt_qty_dest
6666: FROM mtl_material_transactions_temp mmtt
6667: WHERE decode(mmtt.transaction_action_id,3,
6668: mmtt.transfer_organization,mmtt.organization_id) = p_organization_id
6669: AND mmtt.inventory_item_id = p_inventory_item_id
6670: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')

Line 6697: FROM mtl_material_transactions_temp mmtt

6693: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
6694: Sign(mmtt.primary_quantity)))
6695: * round(Abs(mmtt.primary_quantity),5))
6696: INTO l_mmtt_qty_src
6697: FROM mtl_material_transactions_temp mmtt
6698: WHERE mmtt.organization_id = p_organization_id
6699: AND mmtt.inventory_item_id = p_inventory_item_id
6700: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
6701: AND mmtt.subinventory_code = p_subinventory_code

Line 6734: FROM mtl_material_transactions_temp mmtt

6730: Decode(mmtt.transaction_action_id,1,-1,2,-1,28,-1,3,-1,
6731: Sign(mmtt.primary_quantity)))
6732: * round(Abs(mmtt.primary_quantity),5))
6733: INTO l_mmtt_qty_src
6734: FROM mtl_material_transactions_temp mmtt
6735: WHERE mmtt.organization_id = p_organization_id
6736: AND mmtt.inventory_item_id = p_inventory_item_id
6737: AND nvl(mmtt.revision,'@@') = nvl(p_revision,'@@')
6738: AND mmtt.subinventory_code = p_subinventory_code

Line 8427: -- MTL_MATERIAL_TRANSACTIONS_TEMP );

8423: -- input parameters and creates recommendations
8424: -- Pre-reqs : Record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
8425: -- identified by parameters p_transaction_temp_id and
8426: -- p_type_code ( base table for the view is
8427: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
8428: -- At least one transaction detail record in
8429: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
8430: -- and parameters p_transaction_temp_id and p_type_code
8431: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 8431: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

8427: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
8428: -- At least one transaction detail record in
8429: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
8430: -- and parameters p_transaction_temp_id and p_type_code
8431: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
8432: -- WMS_TRANSACTIONS_TEMP, respectively );
8433: -- Rule record has to exist in WMS_RULES_B uniquely
8434: -- identified by parameter p_rule_id;
8435: -- Package WMS_RULE_(RULEID) must exist;

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

15453: ELSIF (l_type_code = 7) THEN
15454: -- Generate package for Operation Plan Rules
15455: g_stmt := 'select count(*) '
15456: || ' from '
15457: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')
15458: || ' where mmtt.transaction_temp_id = p_pp_transaction_temp_id '
15459: || g_rule_where;
15460: --assemble create package statement
15461: l_pack_sql :=

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

15517: ELSIF (l_type_code = 3) THEN
15518: -- Generate package for Task Type Rules
15519: g_stmt := 'select count(*) '
15520: || ' from '
15521: || NVL(g_rule_from, 'MTL_MATERIAL_TRANSACTIONS_TEMP mmtt')
15522: || ' where (MMTT.PARENT_LINE_ID = p_pp_transaction_temp_id or MMTT.TRANSACTION_TEMP_ID = p_pp_transaction_temp_id) ' -- Bug Fix 5560849, 8546026(High vol project)
15523: || g_rule_where;
15524: --assemble create package statement
15525: l_pack_sql :=

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

16423: -- Current version 1.0
16424: --
16425: -- Notes : calls Assign_operation_plan(p_task_id NUMBER)
16426: --
16427: -- This procedure loops through mtl_material_transactions_temp table, assign
16428: -- user defined operation plans to tasks that have not been assigned a operation_plan
16429: -- for the given Move Order Header.
16430: --
16431:

Line 16445: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

16441: , p_move_order_header_id IN NUMBER
16442: ) IS
16443: CURSOR c_tasks IS
16444: SELECT mmtt.transaction_temp_id
16445: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
16446: WHERE mmtt.operation_plan_id IS NULL
16447: AND mmtt.move_order_line_id = mol.line_id
16448: AND mol.header_id = p_move_order_header_id;
16449:

Line 16471: FROM mtl_material_transactions_temp mmtt,

16467: WHERE rules.type_code = 7
16468: AND rules.enabled_flag = 'Y'
16469: AND (organization_id = -1
16470: OR organization_id IN (SELECT mmtt.organization_id
16471: FROM mtl_material_transactions_temp mmtt,
16472: mtl_txn_request_lines mol
16473: WHERE mmtt.operation_plan_id IS NULL /*bug9128227*/
16474: AND mmtt.move_order_line_id = mol.line_id
16475: AND mol.header_id = p_move_order_header_id)));

Line 16526: UPDATE mtl_material_transactions_temp mmtt

16522: -- No rules exist for outbound operaton plan selection.
16523: -- Just stamp the org default outbound operation plan or the default
16524: -- "Locator and LPN Based Consolidation in Staging Lane" seeded outbound operation plan
16525: -- for the MMTT records associated with the move order header.
16526: UPDATE mtl_material_transactions_temp mmtt
16527: SET mmtt.operation_plan_id = (SELECT NVL(default_pick_op_plan_id, 1)
16528: FROM mtl_parameters mp
16529: WHERE mp.organization_id = mmtt.organization_id)
16530: WHERE mmtt.operation_plan_id IS NULL

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

16552: --
16553: -- Notes :
16554: --
16555: -- This procedure assign user defined operation plan to a specific task in
16556: -- mtl_material_transactions_temp. Operation plan is implemeted by WMS rules.
16557: -- This procedure calls the rule package created for operation plan rules to check
16558: -- which operation plan rule actually matches the task in question.
16559:
16560:

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

16589: SELECT rules.rule_id
16590: , mmtt.organization_id
16591: , mmtt.wms_task_type
16592: , rules.type_hdr_id
16593: FROM wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt
16594: WHERE rules.type_code = 7
16595: AND rules.enabled_flag = 'Y'
16596: AND rules.type_hdr_id = wop.operation_plan_id
16597: AND wop.system_task_type = NVL(mmtt.wms_task_type, wop.system_task_type)

Line 16669: UPDATE mtl_material_transactions_temp mmtt

16665:
16666: -- update mmtt table to assign the operation plan
16667:
16668:
16669: UPDATE mtl_material_transactions_temp mmtt
16670: SET mmtt.operation_plan_id = l_operation_plan_id
16671: WHERE mmtt.transaction_temp_id = p_task_id;
16672:
16673: EXIT; -- operation plan assigned, jump out of the rule loop

Line 16691: from mtl_material_transactions_temp

16687:
16688: begin
16689: select organization_id
16690: into l_organization_id
16691: from mtl_material_transactions_temp
16692: where transaction_temp_id = p_task_id
16693: AND transaction_source_type_id IN (2, 8); -- bug fix 3361560
16694: exception
16695: when others then

Line 16713: UPDATE mtl_material_transactions_temp mmtt

16709: END IF;
16710:
16711: l_operation_plan_id := g_default_operation_plan_id;
16712:
16713: UPDATE mtl_material_transactions_temp mmtt
16714: SET mmtt.operation_plan_id = l_operation_plan_id
16715: WHERE mmtt.transaction_temp_id = p_task_id;
16716: END IF;
16717:

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

16760: -- Current version 1.0
16761: --
16762: -- Notes : calls AssignTTs(p_task_id NUMBER)
16763: --
16764: -- This procedure loops through mtl_material_transactions_temp table, assign
16765: -- user defined task type to tasks that have not been assigned a task type
16766: -- for the given Move Order Header.
16767: --
16768:

Line 16784: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

16780: CURSOR c_tasks IS
16781: SELECT mmtt.transaction_temp_id
16782: ,mmtt.organization_id -- Added new
16783: ,mmtt.wms_task_type -- Added new
16784: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
16785: WHERE mmtt.standard_operation_id IS NULL
16786: AND mmtt.move_order_line_id = mol.line_id
16787: AND mol.header_id = p_move_order_header_id;
16788:

Line 16813: FROM mtl_material_transactions_temp mmtt,

16809: WHERE rules.type_code = 3
16810: AND rules.enabled_flag = 'Y'
16811: AND (organization_id = -1
16812: OR organization_id IN (SELECT mmtt.organization_id
16813: FROM mtl_material_transactions_temp mmtt,
16814: mtl_txn_request_lines mol
16815: WHERE mmtt.standard_operation_id IS NULL
16816: AND mmtt.move_order_line_id = mol.line_id
16817: AND mol.header_id = p_move_order_header_id)));

Line 16851: UPDATE mtl_material_transactions_temp mmtt

16847: ELSE
16848: -- Bug# 4587423
16849: -- No valid rules exist for task type assignment so just stamp the org level
16850: -- default task type for the given WMS task type on the MMTT record.
16851: UPDATE mtl_material_transactions_temp mmtt
16852: SET standard_operation_id =
16853: (SELECT DECODE(mmtt.wms_task_type, 1, default_pick_task_type_id,
16854: 2, default_putaway_task_type_id,
16855: 3, default_cc_task_type_id,

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

16882: --
16883: -- Notes :
16884: --
16885: -- This procedure assign user defined task types to a specific task in
16886: -- mtl_material_transactions_temp. Task type is implemeted by WMS rules.
16887: -- This procedure calls the rule package created for task type rules to check
16888: -- which task type rule actually matches the task in question.
16889: --
16890:

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

16936: SELECT rules.rule_id
16937: , rules.type_hdr_id /* Added this Column */
16938: , mmtt.organization_id
16939: , mmtt.wms_task_type
16940: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
16941: WHERE rules.type_code = 3
16942: AND rules.enabled_flag = 'Y'
16943: AND rules.type_hdr_id = bso.standard_operation_id
16944: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)

Line 17056: UPDATE mtl_material_transactions_temp mmtt

17052: l_found := TRUE;
17053:
17054: -- update mmtt table to assign the task type
17055:
17056: UPDATE mtl_material_transactions_temp mmtt
17057: SET mmtt.standard_operation_id = l_type_hdr_id
17058: WHERE mmtt.transaction_temp_id = p_task_id;
17059: /*
17060: UPDATE mtl_material_transactions_temp mmtt

Line 17060: UPDATE mtl_material_transactions_temp mmtt

17056: UPDATE mtl_material_transactions_temp mmtt
17057: SET mmtt.standard_operation_id = l_type_hdr_id
17058: WHERE mmtt.transaction_temp_id = p_task_id;
17059: /*
17060: UPDATE mtl_material_transactions_temp mmtt
17061: SET mmtt.standard_operation_id = (SELECT type_hdr_id
17062: FROM wms_rules_b
17063: WHERE rule_id = l_rule_id)
17064: WHERE mmtt.transaction_temp_id = p_task_id

Line 17085: from mtl_material_transactions_temp

17081: -- bug 2737846
17082: begin
17083: select organization_id, wms_task_type
17084: into l_organization_id, l_wms_task_type
17085: from mtl_material_transactions_temp
17086: where transaction_temp_id = p_task_id;
17087: exception
17088: when others then
17089: null;

Line 17149: UPDATE mtl_material_transactions_temp mmtt

17145:
17146: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
17147: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
17148:
17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id
17151: WHERE mmtt.transaction_temp_id = p_task_id;
17152:
17153: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);

Line 18317: -- MTL_MATERIAL_TRANSACTIONS_TEMP );

18313: -- input parameters and creates recommendations
18314: -- Pre-reqs : Record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
18315: -- identified by parameters p_transaction_temp_id and
18316: -- p_type_code ( base table for the view is
18317: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
18318: -- At least one transaction detail record in
18319: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
18320: -- and parameters p_transaction_temp_id and p_type_code
18321: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

Line 18321: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and

18317: -- MTL_MATERIAL_TRANSACTIONS_TEMP );
18318: -- At least one transaction detail record in
18319: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
18320: -- and parameters p_transaction_temp_id and p_type_code
18321: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
18322: -- WMS_TRANSACTIONS_TEMP, respectively );
18323: -- Rule record has to exist in WMS_RULES_B uniquely
18324: -- identified by parameter p_rule_id;
18325: -- Package WMS_RULE_(RULEID) must exist;