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 161: FROM msc_supplies

157: location NUMBER :=1;
158: cursor lookUpSupplies( C_lineLocationId NUMBER, C_srInstanceId NUMBER) is
159: SELECT order_number, purch_line_num, order_type
160: --INTO v_order_Number, v_line_Number, v_order_type
161: FROM msc_supplies
162: WHERE msc_supplies.po_line_location_id = c_lineLocationId
163: and plan_id = -1
164: and msc_supplies.sr_instance_id = c_srInstanceId
165: and msc_supplies.order_type in (1, 11);

Line 162: WHERE msc_supplies.po_line_location_id = c_lineLocationId

158: cursor lookUpSupplies( C_lineLocationId NUMBER, C_srInstanceId NUMBER) is
159: SELECT order_number, purch_line_num, order_type
160: --INTO v_order_Number, v_line_Number, v_order_type
161: FROM msc_supplies
162: WHERE msc_supplies.po_line_location_id = c_lineLocationId
163: and plan_id = -1
164: and msc_supplies.sr_instance_id = c_srInstanceId
165: and msc_supplies.order_type in (1, 11);
166:

Line 164: and msc_supplies.sr_instance_id = c_srInstanceId

160: --INTO v_order_Number, v_line_Number, v_order_type
161: FROM msc_supplies
162: WHERE msc_supplies.po_line_location_id = c_lineLocationId
163: and plan_id = -1
164: and msc_supplies.sr_instance_id = c_srInstanceId
165: and msc_supplies.order_type in (1, 11);
166:
167:
168: begin

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

161: FROM msc_supplies
162: WHERE msc_supplies.po_line_location_id = c_lineLocationId
163: and plan_id = -1
164: and msc_supplies.sr_instance_id = c_srInstanceId
165: and msc_supplies.order_type in (1, 11);
166:
167:
168: begin
169: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');

Line 271: FROM msc_supplies

267: END LOOP;
268: CLOSE lookUpSupplies;
269: /* SELECT distinct order_number, purch_line_num, order_type
270: INTO v_order_Number, v_line_Number, v_order_type
271: FROM msc_supplies
272: WHERE msc_supplies.po_line_location_id = lineLocationId
273: and plan_id = -1
274: and msc_supplies.sr_instance_id = srInstanceId
275: -- and msc_supplies.order_type in (1, 11);

Line 272: WHERE msc_supplies.po_line_location_id = lineLocationId

268: CLOSE lookUpSupplies;
269: /* SELECT distinct order_number, purch_line_num, order_type
270: INTO v_order_Number, v_line_Number, v_order_type
271: FROM msc_supplies
272: WHERE msc_supplies.po_line_location_id = lineLocationId
273: and plan_id = -1
274: and msc_supplies.sr_instance_id = srInstanceId
275: -- and msc_supplies.order_type in (1, 11);
276: and msc_supplies.order_type=11;*/

Line 274: and msc_supplies.sr_instance_id = srInstanceId

270: INTO v_order_Number, v_line_Number, v_order_type
271: FROM msc_supplies
272: WHERE msc_supplies.po_line_location_id = lineLocationId
273: and plan_id = -1
274: and msc_supplies.sr_instance_id = srInstanceId
275: -- and msc_supplies.order_type in (1, 11);
276: and msc_supplies.order_type=11;*/
277:
278:

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

271: FROM msc_supplies
272: WHERE msc_supplies.po_line_location_id = lineLocationId
273: and plan_id = -1
274: and msc_supplies.sr_instance_id = srInstanceId
275: -- and msc_supplies.order_type in (1, 11);
276: and msc_supplies.order_type=11;*/
277:
278:
279:

Line 276: and msc_supplies.order_type=11;*/

272: WHERE msc_supplies.po_line_location_id = lineLocationId
273: and plan_id = -1
274: and msc_supplies.sr_instance_id = srInstanceId
275: -- and msc_supplies.order_type in (1, 11);
276: and msc_supplies.order_type=11;*/
277:
278:
279:
280: status := 'SUCCESS';

Line 510: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

506: s.new_dock_date, s.order_number,
507: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID, s.SOURCE_ORGANIZATION_ID
508: 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,
509: v_source_sr_inst_id, v_sr_org_id
510: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
511: WHERE s.ORDER_TYPE = 11
512: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
513: AND s.SUPPLIER_ID is not null
514: AND s.PLAN_ID = planId

Line 525: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

521: s.supplier_site_id, s.new_dock_date, s.order_number,
522: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID,s.SOURCE_ORGANIZATION_ID
523: 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,
524: v_source_sr_inst_id, v_sr_org_id
525: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
526: WHERE s.ORDER_TYPE = 1
527: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
528: AND s.PO_LINE_ID = tu.PO_LINE_ID
529: AND s.PLAN_ID =planId

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

648: status out nocopy varchar2) IS
649: cursor GetSupplierDataForIR_shipment( srIId IN NUMBER) is
650: SELECT s2.transaction_id, s2.supplier_id, s2.supplier_site_id, s2.new_dock_date, s2.order_number, s2.INVENTORY_ITEM_ID,
651: s2.SOURCE_ORGANIZATION_ID , s2.ORGANIZATION_ID, s2.NEW_ORDER_QUANTITY, s2.SR_INSTANCE_ID
652: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
653: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
654: AND s2.PLAN_ID =planId
655: AND s2.SR_INSTANCE_ID = srIId
656: AND SO.SR_INSTANCE_ID = srIId

Line 704: FROM MSC_SUPPLIES s, MSC_DEMANDS d

700: SELECT distinct s.transaction_id, s.supplier_id, s.supplier_site_id, s.new_dock_date, s.order_number, d.INVENTORY_ITEM_ID,
701: d.SOURCE_ORGANIZATION_ID , d.ORGANIZATION_ID, s.NEW_ORDER_QUANTITY, s.SR_INSTANCE_ID--IR
702: INTO supp_Transaction_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_inv_item_id,
703: v_sr_org_id, v_org_id, v_q, v_source_sr_Inst_id
704: FROM MSC_SUPPLIES s, MSC_DEMANDS d
705: WHERE s.ORDER_TYPE = 2 -- IR
706: AND s.TRANSACTION_ID = d.DISPOSITION_ID
707: AND s.PLAN_ID =planId
708: AND s.SR_INSTANCE_ID = SrInstanceId

Line 846: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

842: status out nocopy varchar2) IS
843:
844: cursor GetPOIds is
845: SELECT s.TRANSACTION_ID
846: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
847: WHERE s.ORDER_TYPE = 1
848: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
849: AND s.PO_LINE_ID = tu.PO_LINE_ID
850: AND s.PLAN_ID =planId

Line 856: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

852: AND tu.TRANS_UPDATE_ID = transId;
853:
854: cursor GetPOShipmentIds is
855: SELECT s.TRANSACTION_ID
856: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
857: WHERE s.ORDER_TYPE = 11
858: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
859: AND s.SUPPLIER_ID is not null
860: AND s.PLAN_ID = planId

Line 896: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

892:
893: if ( i = 1) then -- PO shipment, not PO
894: isPoShipment := 1;
895: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
896: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
897: WHERE s.ORDER_TYPE = 11
898: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
899: AND s.PLAN_ID =planId
900: AND s.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 906: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

902:
903: else
904: isPoShipment := 0;
905: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
906: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
907: WHERE s.ORDER_TYPE = 1
908: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
909: AND s.PO_LINE_ID = tu.PO_LINE_ID
910: AND s.PLAN_ID =planId

Line 953: UPDATE MSC_SUPPLIES

949: i:=0;
950: FOR i IN 1 .. PO_Ids.COUNT
951: LOOP
952: --dbms_output.put_line(' tranz_id = ' || PO_Ids(i));
953: UPDATE MSC_SUPPLIES
954: Set FIRM_DATE = v_new_firm_Date,
955: APPLIED = 2,
956: STATUS = 0,
957: FIRM_PLANNED_TYPE = 1,

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

980: PROCEDURE UpdateNewColumnAndFirmDate_SO( planId IN NUMBER,
981: transId IN NUMBER , status out nocopy varchar2) IS
982: /*cursor GetIR_Shipments( srIId IN NUMBER ) is
983: SELECT s2.TRANSACTION_ID
984: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
985: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
986: AND s2.PLAN_ID =planId
987: AND s2.SR_INSTANCE_ID = srIId
988: AND SO.SR_INSTANCE_ID = srIId

Line 1060: FROM MSC_SUPPLIES s, MSC_DEMANDS d

1056:
1057: --dbms_output.put_line(ISOID1);
1058: SELECT distinct s.TRANSACTION_ID --IR_Ids
1059: INTO IRID1
1060: FROM MSC_SUPPLIES s, MSC_DEMANDS d
1061: WHERE s.ORDER_TYPE = 2 -- IR
1062: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1063: AND s.PLAN_ID =planId
1064: AND d.PLAN_ID =planId

Line 1098: UPDATE MSC_SUPPLIES

1094: WHERE TRANS_UPDATE_ID = transId;
1095:
1096: -- IR for now, IR shipment later
1097: --update both IRs and IR shipments
1098: UPDATE MSC_SUPPLIES
1099: Set FIRM_DATE = v_new_firm_Date,
1100: APPLIED = 2,
1101: STATUS = 0,
1102: FIRM_PLANNED_TYPE = 1,

Line 1139: FROM MSC_SUPPLIES s, MSC_DEMANDS d

1135: AND tu.Trans_update_id = transId;
1136:
1137: cursor GetIR_IDs (srIId IN NUMBER) is
1138: SELECT s.TRANSACTION_ID --IR_Ids
1139: FROM MSC_SUPPLIES s, MSC_DEMANDS d
1140: WHERE s.ORDER_TYPE = 2 -- IR
1141: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1142: AND s.PLAN_ID =planId
1143: AND s.SR_INSTANCE_ID = srIId

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

1152:
1153:
1154: cursor GetIR_Shipments( srIId IN NUMBER ) is
1155: SELECT s2.TRANSACTION_ID
1156: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1157: WHERE s2.ORDER_TYPE = 11 -- IR Shipment
1158: AND s2.PLAN_ID =planId
1159: AND s2.SR_INSTANCE_ID = srIId
1160: AND SO.SR_INSTANCE_ID = srIId

Line 1282: UPDATE MSC_SUPPLIES

1278:
1279: FOR i IN 1 .. IR_Ids.COUNT
1280: LOOP
1281: --update both IRs and IR shipments
1282: UPDATE MSC_SUPPLIES
1283: Set FIRM_DATE = v_new_firm_Date,
1284: APPLIED = 2,
1285: STATUS = 0,
1286: FIRM_PLANNED_TYPE = 1,

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

1547: --dbms_output.put_line(v_itemId || ' ' || v_orderNumber );
1548: else
1549: SELECT s2.order_number, s2.INVENTORY_ITEM_ID, s2.ORGANIZATION_ID
1550: INTO v_orderNumber, v_itemId, v_orgId
1551: FROM MSC_SUPPLIES s2, MSC_SALES_ORDERS sO, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1552: WHERE s2.PLAN_ID =-1
1553: AND s2.SR_INSTANCE_ID = v_srInstanceId
1554: AND SO.SR_INSTANCE_ID = v_srInstanceId
1555: AND dd.SR_INSTANCE_ID = v_srInstanceId

Line 1595: from msc_supplies

1591: inventoryItemId out nocopy NUMBER,
1592: orgId out nocopy NUMBER) is
1593: cursor GetOrderNumber is
1594: select distinct order_number, inventory_item_id, ORGANIZATION_ID
1595: from msc_supplies
1596: WHERE PLAN_ID= -1
1597: AND SR_INSTANCE_ID=srInstanceId
1598: AND ORDER_TYPE= 1
1599: AND PO_line_LOCATION_ID = lineLocationId;