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 648: Delete from MRP_IRO_RELEASE mir

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

Line 652: And exists ( select 1 from mrp_iro_release mir1

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

Line 1417: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;

1413:
1414: END loop;
1415: retcode := global_retcode;
1416:
1417: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;
1418: Commit;
1419: DELETE FROm MRP_ORG_TRANSFER_RELEASE WHERE BATCH_ID=p_batch_id;
1420: Commit;
1421: END Release_new_IRO;