eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SRP_RELEASE dependencies on MRP_ERO_RELEASE

Line 26: from MRP_ERO_RELEASE

22: p_batch_id IN number) IS
23:
24: Cursor Ro_release_data( p_batch_id number) is
25: Select *
26: from MRP_ERO_RELEASE
27: where batch_id =p_batch_id
28: order by transaction_id ;
29:
30:

Line 53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;

49: l_level_id number;
50: l_level_value number;
51: lv_req_number number ;
52:
53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;
54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;

Line 54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;

50: l_level_value number;
51: lv_req_number number ;
52:
53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;
54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;

Line 55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;

51: lv_req_number number ;
52:
53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;
54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;

Line 56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;

52:
53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;
54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;
60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;

Line 57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;

53: Lv_repair_supplier_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ID%Type;
54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;
60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;
61: l_msg VARCHAR2(5000);

Line 58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;

54: Lv_repair_org_id MRP_ERO_RELEASE.REPAIR_SUPPLIER_ORG_ID%Type;
55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;
60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;
61: l_msg VARCHAR2(5000);
62: BEGIN

Line 59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;

55: Lv_repair_program MRP_ERO_RELEASE.REPAIR_PROGRAM%Type;
56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;
60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;
61: l_msg VARCHAR2(5000);
62: BEGIN
63: log_output(' Repair Purchase Order Release Report');

Line 60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;

56: Lv_destination_org_id MRP_ERO_RELEASE.DESTINATION_ORG_ID%Type;
57: Lv_source_org_id MRP_ERO_RELEASE.SOURCE_ORG_ID%Type;
58: Lv_inventory_item_id MRP_ERO_RELEASE.INVENTORY_ITEM_ID%Type;
59: Lv_quantity MRP_ERO_RELEASE.QUANTITY%Type;
60: Lv_promise_date MRP_ERO_RELEASE.PROMISE_DATE%Type;
61: l_msg VARCHAR2(5000);
62: BEGIN
63: log_output(' Repair Purchase Order Release Report');
64: log_output('--------------------------------------------------------------------------------------------------');

Line 328: DELETE FROM MRP_ERO_RELEASE WHERE BATCH_ID=p_batch_id ;

324: log_message('Transaction rolled back');
325: log_message('----------------------------------------------------------');
326: End;
327:
328: DELETE FROM MRP_ERO_RELEASE WHERE BATCH_ID=p_batch_id ;
329: Commit;
330:
331: END Release_new_ERO;
332: