DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1477: select MTL_MATERIAL_TRANSACTIONS_S.nextval into x_new_txn_hdr

1473: return number is
1474: x_new_txn_hdr number;
1475: begin
1476:
1477: select MTL_MATERIAL_TRANSACTIONS_S.nextval into x_new_txn_hdr
1478: from sys.dual ;
1479:
1480:
1481: Update Mtl_transactions_interface

Line 1602: from mtl_material_transactions

1598: x_scr_qty, -- CFM Scrap
1599: x_txn_date,
1600: x_flow_schedule,
1601: x_last_updated_by
1602: from mtl_material_transactions
1603: where transaction_set_id = p_header_id
1604: and transaction_action_id in (31, 32, 30); -- CFM Scrap
1605:
1606: x_success := Update_Flow_Schedule( x_wip_entity_id, x_cpl_qty, x_scr_qty, -- CFM Scrap