DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 681: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;

677: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
678:
679:
680: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
681: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
682:
683:
684: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
685: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

Line 1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;

1064:
1065: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1066:
1067: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1069:
1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,

Line 1632: from mtl_txn_request_lines mtrl

1628:
1629: -- Bug #3387877
1630: select nvl(mtrl.transaction_source_type_id,0) , nvl(mtrl.reference_id, 0)
1631: into l_transaction_source_type_id, l_reference_id
1632: from mtl_txn_request_lines mtrl
1633: where mtrl.line_id = p_move_order_line_id;
1634: --
1635: if l_debug = 1 then
1636: log_event(l_api_name,' Txn_source_type_id ' ,l_transaction_source_type_id);