DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 892: mtl_material_transactions where

888: and reference_id = p_Kanban_card_Id
889: and line_status in (3,7);
890: if (l_reference_type_code = 1) then
891: select sum(abs(transaction_quantity)) into l_quantity_delivered from
892: mtl_material_transactions where
893: move_order_line_id = l_move_order_line_id and
894: transaction_quantity < 0;
895: if (nvl(l_quantity_delivered,0) < l_quantity) then
896: l_Supply_Status := INV_KANBAN_PVT.G_Supply_Status_InProcess;

Line 3962: SELECT mtl_material_transactions_s.NEXTVAL

3958: FETCH mo_lines_cur INTO l_mo_line_rec;
3959: EXIT WHEN mo_lines_cur%NOTFOUND;
3960:
3961: /*Get the next header id*/
3962: SELECT mtl_material_transactions_s.NEXTVAL
3963: INTO l_txn_header_id
3964: FROM DUAL;
3965:
3966: /* Check whether item is serial controlled or not */