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_DEMANDS

Line 667: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

663: where TRANS_UPDATE_ID = transId;
664:
665: SELECT distinct d.DEMAND_ID
666: INTO ISOID1
667: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
668: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
669: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
670: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID
671: AND d.PLAN_ID = planId

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 996: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

992: where TRANS_UPDATE_ID = transId;
993:
994: -- is this only one result ????? or more ???
995: select distinct d.INVENTORY_ITEM_ID, d.SOURCE_ORGANIZATION_ID into invItemId, orgId
996: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
997: WHERE d.SALES_ORDER_LINE_ID = to_char(dd.SOURCE_LINE_ID)
998: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
999: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1000: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 1007: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1003: AND tu.TRANS_UPDATE_ID = transId;
1004:
1005: SELECT distinct d.DEMAND_ID
1006: into ISOID1
1007: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1008: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1009: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1010: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1011: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 1022: UPDATE MSC_DEMANDS

1018:
1019:
1020: --Update all ISOs
1021:
1022: UPDATE MSC_DEMANDS
1023: Set OTM_ARRIVAL_DATE = newArrivalDate,
1024: LAST_UPDATE_DATE = SYSDATE,
1025: LAST_UPDATED_BY = userId
1026: WHERE PLAN_ID = planId

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 1103: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1099: PROCEDURE UpdateNewColumnAndFirmDate_SO_( planId IN NUMBER,
1100: transId IN NUMBER , status out nocopy varchar2) IS
1101: cursor GetISOs is
1102: SELECT d.DEMAND_ID
1103: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1104: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1105: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1106: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1107: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

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 1120: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1116: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1117: AND s.PLAN_ID =planId
1118: AND s.SR_INSTANCE_ID = srIId
1119: AND d.DEMAND_ID IN ( SELECT d.DEMAND_ID
1120: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1121: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1122: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1123: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID
1124: AND d.PLAN_ID = planId

Line 1171: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu

1167: --dbms_output.put_line(planId);
1168:
1169: -- is this only one result ????? or more ???
1170: select d.INVENTORY_ITEM_ID, d.SOURCE_ORGANIZATION_ID into invItemId, orgId
1171: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1172: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1173: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1174: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1175: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 1201: UPDATE MSC_DEMANDS

1197: --Update all ISOs
1198: i:=1;
1199: FOR i IN 1 .. ISO_Ids.COUNT
1200: LOOP
1201: UPDATE MSC_DEMANDS
1202: Set OTM_ARRIVAL_DATE = newArrivalDate,
1203: LAST_UPDATE_DATE = SYSDATE,
1204: LAST_UPDATED_BY = userId
1205: WHERE PLAN_ID = planId