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_WS_OTM_BPEL dependencies on MSC_SUPPLIES

Line 166: FROM msc_supplies

162:
163:
164: SELECT distinct order_number, purch_line_num, order_type
165: INTO v_order_Number, v_line_Number, v_order_type
166: FROM msc_supplies
167: WHERE msc_supplies.po_line_location_id = lineLocationId
168: and plan_id = -1
169: and msc_supplies.sr_instance_id = srInstanceId
170: and msc_supplies.order_type in (1, 11);

Line 167: WHERE msc_supplies.po_line_location_id = lineLocationId

163:
164: SELECT distinct order_number, purch_line_num, order_type
165: INTO v_order_Number, v_line_Number, v_order_type
166: FROM msc_supplies
167: WHERE msc_supplies.po_line_location_id = lineLocationId
168: and plan_id = -1
169: and msc_supplies.sr_instance_id = srInstanceId
170: and msc_supplies.order_type in (1, 11);
171:

Line 169: and msc_supplies.sr_instance_id = srInstanceId

165: INTO v_order_Number, v_line_Number, v_order_type
166: FROM msc_supplies
167: WHERE msc_supplies.po_line_location_id = lineLocationId
168: and plan_id = -1
169: and msc_supplies.sr_instance_id = srInstanceId
170: and msc_supplies.order_type in (1, 11);
171:
172: --dbms_output.put_line('orderNumber=' || v_order_Number);
173:

Line 170: and msc_supplies.order_type in (1, 11);

166: FROM msc_supplies
167: WHERE msc_supplies.po_line_location_id = lineLocationId
168: and plan_id = -1
169: and msc_supplies.sr_instance_id = srInstanceId
170: and msc_supplies.order_type in (1, 11);
171:
172: --dbms_output.put_line('orderNumber=' || v_order_Number);
173:
174: select decode(instr(v_order_Number,'('), 0, v_order_Number, substr(v_order_Number, 1, instr(v_order_Number,'(') - 1))

Line 485: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

481: s.new_dock_date, s.order_number,
482: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID, s.SOURCE_ORGANIZATION_ID
483: INTO supp_Transaction_id, newArrivalDate, srInstanceId, v_org_id, v_inv_item_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_q,
484: v_source_sr_inst_id, v_sr_org_id
485: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
486: WHERE s.ORDER_TYPE = 11
487: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
488: AND s.SUPPLIER_ID is not null
489: AND s.PLAN_ID = planId

Line 500: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

496: s.supplier_site_id, s.new_dock_date, s.order_number,
497: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID,s.SOURCE_ORGANIZATION_ID
498: INTO supp_Transaction_id, newArrivalDate, srInstanceId, v_org_id, v_inv_item_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_q,
499: v_source_sr_inst_id, v_sr_org_id
500: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
501: WHERE s.ORDER_TYPE = 1
502: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
503: AND s.PO_LINE_ID = tu.PO_LINE_ID
504: AND s.PLAN_ID =planId

Line 627: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

623: status out nocopy varchar2) IS
624: cursor GetSupplierDataForIR_shipment( srIId IN NUMBER) is
625: SELECT s2.transaction_id, s2.supplier_id, s2.supplier_site_id, s2.new_dock_date, s2.order_number, s2.INVENTORY_ITEM_ID,
626: s2.SOURCE_ORGANIZATION_ID , s2.ORGANIZATION_ID, s2.NEW_ORDER_QUANTITY, s2.SR_INSTANCE_ID
627: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
628: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
629: AND s2.PLAN_ID =planId
630: AND s2.SR_INSTANCE_ID = srIId
631: AND SO.SR_INSTANCE_ID = srIId

Line 679: FROM MSC_SUPPLIES s, MSC_DEMANDS d

675: SELECT distinct s.transaction_id, s.supplier_id, s.supplier_site_id, s.new_dock_date, s.order_number, d.INVENTORY_ITEM_ID,
676: d.SOURCE_ORGANIZATION_ID , d.ORGANIZATION_ID, s.NEW_ORDER_QUANTITY, s.SR_INSTANCE_ID--IR
677: INTO supp_Transaction_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_inv_item_id,
678: v_sr_org_id, v_org_id, v_q, v_source_sr_Inst_id
679: FROM MSC_SUPPLIES s, MSC_DEMANDS d
680: WHERE s.ORDER_TYPE = 2 -- IR
681: AND s.TRANSACTION_ID = d.DISPOSITION_ID
682: AND s.PLAN_ID =planId
683: AND s.SR_INSTANCE_ID = SrInstanceId

Line 821: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

817: status out nocopy varchar2) IS
818:
819: cursor GetPOIds is
820: SELECT s.TRANSACTION_ID
821: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
822: WHERE s.ORDER_TYPE = 1
823: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
824: AND s.PO_LINE_ID = tu.PO_LINE_ID
825: AND s.PLAN_ID =planId

Line 831: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

827: AND tu.TRANS_UPDATE_ID = transId;
828:
829: cursor GetPOShipmentIds is
830: SELECT s.TRANSACTION_ID
831: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
832: WHERE s.ORDER_TYPE = 11
833: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
834: AND s.SUPPLIER_ID is not null
835: AND s.PLAN_ID = planId

Line 871: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

867:
868: if ( i = 1) then -- PO shipment, not PO
869: isPoShipment := 1;
870: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
871: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
872: WHERE s.ORDER_TYPE = 11
873: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
874: AND s.PLAN_ID =planId
875: AND s.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 881: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

877:
878: else
879: isPoShipment := 0;
880: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
881: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
882: WHERE s.ORDER_TYPE = 1
883: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
884: AND s.PO_LINE_ID = tu.PO_LINE_ID
885: AND s.PLAN_ID =planId

Line 928: UPDATE MSC_SUPPLIES

924: i:=0;
925: FOR i IN 1 .. PO_Ids.COUNT
926: LOOP
927: --dbms_output.put_line(' tranz_id = ' || PO_Ids(i));
928: UPDATE MSC_SUPPLIES
929: Set FIRM_DATE = v_new_firm_Date,
930: APPLIED = 2,
931: STATUS = 0,
932: FIRM_PLANNED_TYPE = 1,

Line 959: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

955: PROCEDURE UpdateNewColumnAndFirmDate_SO( planId IN NUMBER,
956: transId IN NUMBER , status out nocopy varchar2) IS
957: /*cursor GetIR_Shipments( srIId IN NUMBER ) is
958: SELECT s2.TRANSACTION_ID
959: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
960: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
961: AND s2.PLAN_ID =planId
962: AND s2.SR_INSTANCE_ID = srIId
963: AND SO.SR_INSTANCE_ID = srIId

Line 1035: FROM MSC_SUPPLIES s, MSC_DEMANDS d

1031:
1032: --dbms_output.put_line(ISOID1);
1033: SELECT distinct s.TRANSACTION_ID --IR_Ids
1034: INTO IRID1
1035: FROM MSC_SUPPLIES s, MSC_DEMANDS d
1036: WHERE s.ORDER_TYPE = 2 -- IR
1037: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1038: AND s.PLAN_ID =planId
1039: AND d.PLAN_ID =planId

Line 1073: UPDATE MSC_SUPPLIES

1069: WHERE TRANS_UPDATE_ID = transId;
1070:
1071: -- IR for now, IR shipment later
1072: --update both IRs and IR shipments
1073: UPDATE MSC_SUPPLIES
1074: Set FIRM_DATE = v_new_firm_Date,
1075: APPLIED = 2,
1076: STATUS = 0,
1077: FIRM_PLANNED_TYPE = 1,

Line 1114: FROM MSC_SUPPLIES s, MSC_DEMANDS d

1110: AND tu.Trans_update_id = transId;
1111:
1112: cursor GetIR_IDs (srIId IN NUMBER) is
1113: SELECT s.TRANSACTION_ID --IR_Ids
1114: FROM MSC_SUPPLIES s, MSC_DEMANDS d
1115: WHERE s.ORDER_TYPE = 2 -- IR
1116: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1117: AND s.PLAN_ID =planId
1118: AND s.SR_INSTANCE_ID = srIId

Line 1131: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1127:
1128:
1129: cursor GetIR_Shipments( srIId IN NUMBER ) is
1130: SELECT s2.TRANSACTION_ID
1131: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1132: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
1133: AND s2.PLAN_ID =planId
1134: AND s2.SR_INSTANCE_ID = srIId
1135: AND SO.SR_INSTANCE_ID = srIId

Line 1257: UPDATE MSC_SUPPLIES

1253:
1254: FOR i IN 1 .. IR_Ids.COUNT
1255: LOOP
1256: --update both IRs and IR shipments
1257: UPDATE MSC_SUPPLIES
1258: Set FIRM_DATE = v_new_firm_Date,
1259: APPLIED = 2,
1260: STATUS = 0,
1261: FIRM_PLANNED_TYPE = 1,

Line 1526: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1522: --dbms_output.put_line(v_itemId || ' ' || v_orderNumber );
1523: else
1524: SELECT s2.order_number, s2.INVENTORY_ITEM_ID, s2.ORGANIZATION_ID
1525: INTO v_orderNumber, v_itemId, v_orgId
1526: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1527: WHERE s2.PLAN_ID =-1
1528: AND s2.SR_INSTANCE_ID = v_srInstanceId
1529: AND SO.SR_INSTANCE_ID = v_srInstanceId
1530: AND dd.SR_INSTANCE_ID = v_srInstanceId

Line 1570: from msc_supplies

1566: inventoryItemId out nocopy NUMBER,
1567: orgId out nocopy NUMBER) is
1568: cursor GetOrderNumber is
1569: select distinct order_number, inventory_item_id, ORGANIZATION_ID
1570: from msc_supplies
1571: WHERE PLAN_ID= -1
1572: AND SR_INSTANCE_ID=srInstanceId
1573: AND ORDER_TYPE= 1
1574: AND PO_line_LOCATION_ID = lineLocationId;