APPS.MRP_CREATE_SCHEDULE_ISO dependencies on MRP_ORG_TRANSFER_RELEASE

Line 80: Procedure: Create_IR_ISO creates 1 IR + creates 1 ISO for the specific row in mrp_org_transfer_Release

76:
77: END MSC_RELEASE_ISO;
78:
79: /**********************************************************
80: Procedure: Create_IR_ISO creates 1 IR + creates 1 ISO for the specific row in mrp_org_transfer_Release
81: ***********************************************************/
82: PROCEDURE Create_IR_ISO( errbuf OUT NOCOPY VARCHAR2,
83: retcode OUT NOCOPY VARCHAR2,
84: p_Ireq_header_id OUT NOCOPY number,

Line 101: MRP_ORG_TRANSFER_RELEASE

97: uom_code, charge_account_id, group_code, item_revision,
98: project_id, task_id, end_item_number, load_type, firm_demand_flag,
99: ship_method, earliest_ship_date,plan_type,part_condition
100: FROM
101: MRP_ORG_TRANSFER_RELEASE
102: WHERE
103: transaction_id = l_transaction_id
104: ORDER BY src_operating_unit;
105:

Line 811: MRP_ORG_TRANSFER_RELEASE

807: CURSOR c_org_trans_rel(l_batch_id number) IS
808: SELECT
809: batch_id, transaction_id
810: FROM
811: MRP_ORG_TRANSFER_RELEASE
812: WHERE
813: batch_id = l_batch_id
814: ORDER BY src_operating_unit;
815:

Line 846: DELETE from MRP_ORG_TRANSFER_RELEASE

842: commit;
843:
844: END LOOP;
845:
846: DELETE from MRP_ORG_TRANSFER_RELEASE
847: WHERE batch_id = p_batch_id;
848: COMMIT;
849:
850: