APPS.INV_KANBAN_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 881: -- Bug 2383538 Checking the mtl_txn_request_lines when partially

877: -- The status changes to 'InProcess if 'INV_FILL_PARTIAL_MOVE_KANBAN'
878: -- profile value is set to 'No' and the IF conditions are satisfied.
879:
880: if nvl(fnd_profile.value('INV_FILL_PARTIAL_MOVE_KANBAN'),2) = 2 then
881: -- Bug 2383538 Checking the mtl_txn_request_lines when partially
882: -- transacting the move order to change the supply status to Inprocess
883: Begin
884: select line_id, nvl(quantity,0), nvl(reference_type_code,0)
885: into l_move_order_line_id, l_quantity, l_reference_type_code

Line 886: from mtl_txn_request_lines

882: -- transacting the move order to change the supply status to Inprocess
883: Begin
884: select line_id, nvl(quantity,0), nvl(reference_type_code,0)
885: into l_move_order_line_id, l_quantity, l_reference_type_code
886: from mtl_txn_request_lines
887: where reference_type_code = 1
888: and reference_id = p_Kanban_card_Id
889: and line_status in (3,7);
890: if (l_reference_type_code = 1) then

Line 3946: FROM MTL_TXN_REQUEST_LINES MTRL

3942:
3943: /*Cursor to get mo line informations */
3944: CURSOR mo_lines_cur IS
3945: SELECT MTRL.line_id , MTRL.inventory_item_id,MTRL.organization_id,MTRL.quantity
3946: FROM MTL_TXN_REQUEST_LINES MTRL
3947: WHERE MTRL.header_id = p_mo_header_id;
3948:
3949: l_mo_line_rec mo_lines_cur%ROWTYPE;
3950: BEGIN

Line 3994: update mtl_txn_request_lines

3990: p_plan_tasks => FALSE ,
3991: p_commit => TRUE
3992: );
3993:
3994: update mtl_txn_request_lines
3995: set quantity_detailed = l_detailed_quantity
3996: where line_id=l_mo_line_rec.line_id;
3997:
3998: IF (l_debug = 1 ) THEN