APPS.MSC_SRP_RELEASE dependencies on MRP_IRO_RELEASE

Line 588: from MRP_IRO_RELEASE

584: Cursor Ro_release_data( p_batch_id number) is
585: Select Transaction_id,Quantity,in_req_quantity,out_req_quantity,In_req_transaction_id,
586: Out_req_transaction_id,Batch_id,Inventory_item_id
587: Uom_code,Organization_id,Promise_date
588: from MRP_IRO_RELEASE
589: where batch_id =p_batch_id
590: and load_type = IRO_LOAD
591: AND In_req_transaction_id is not NULL;
592:

Line 598: from MRP_IRO_RELEASE

594: Select distinct Transaction_id, Quantity,
595: Out_req_transaction_id, Batch_id, Inventory_item_id,
596: Uom_code, Organization_id, Promise_date ,deliver_to_location_id,
597: src_organization_id,LOAD_TYPE
598: from MRP_IRO_RELEASE
599: where batch_id =p_batch_id
600: and load_type =IRO_LOAD
601: and in_req_transaction_id is null ;
602:

Line 647: Delete from MRP_IRO_RELEASE mir

643: log_output('----------- ----------- -------- -------- ---------------------- ---------------------- -------- ----------------------');
644:
645:
646:
647: Delete from MRP_IRO_RELEASE mir
648: where batch_id =p_batch_id
649: And in_req_transaction_id is null
650: AND load_type = IRO_LOAD
651: And exists ( select 1 from mrp_iro_release mir1

Line 651: And exists ( select 1 from mrp_iro_release mir1

647: Delete from MRP_IRO_RELEASE mir
648: where batch_id =p_batch_id
649: And in_req_transaction_id is null
650: AND load_type = IRO_LOAD
651: And exists ( select 1 from mrp_iro_release mir1
652: Where mir1.batch_id =p_batch_id
653: And mir1.in_req_transaction_id is not null
654: And mir1.transaction_id = mir.transaction_id
655: );

Line 1420: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;

1416:
1417: END loop;
1418: retcode := global_retcode;
1419:
1420: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;
1421: Commit;
1422: DELETE FROm MRP_ORG_TRANSFER_RELEASE WHERE BATCH_ID=p_batch_id;
1423: Commit;
1424: END Release_new_IRO;