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

688: where TRANS_UPDATE_ID = transId;
689:
690: SELECT distinct d.DEMAND_ID
691: INTO ISOID1
692: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
693: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
694: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
695: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID
696: AND d.PLAN_ID = planId

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

1017: where TRANS_UPDATE_ID = transId;
1018:
1019: -- is this only one result ????? or more ???
1020: select distinct d.INVENTORY_ITEM_ID, d.SOURCE_ORGANIZATION_ID into invItemId, orgId
1021: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1022: WHERE d.SALES_ORDER_LINE_ID = to_char(dd.SOURCE_LINE_ID)
1023: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1024: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1025: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

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

1028: AND tu.TRANS_UPDATE_ID = transId;
1029:
1030: SELECT distinct d.DEMAND_ID
1031: into ISOID1
1032: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1033: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1034: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1035: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1036: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 1047: UPDATE MSC_DEMANDS

1043:
1044:
1045: --Update all ISOs
1046:
1047: UPDATE MSC_DEMANDS
1048: Set OTM_ARRIVAL_DATE = newArrivalDate,
1049: LAST_UPDATE_DATE = SYSDATE,
1050: LAST_UPDATED_BY = userId
1051: WHERE PLAN_ID = planId

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

1124: PROCEDURE UpdateNewColumnAndFirmDate_SO_( planId IN NUMBER,
1125: transId IN NUMBER , status out nocopy varchar2) IS
1126: cursor GetISOs is
1127: SELECT d.DEMAND_ID
1128: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1129: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1130: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1131: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1132: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

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

1141: AND s.TRANSACTION_ID = d.DISPOSITION_ID
1142: AND s.PLAN_ID =planId
1143: AND s.SR_INSTANCE_ID = srIId
1144: AND d.DEMAND_ID IN ( SELECT d.DEMAND_ID
1145: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1146: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1147: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1148: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID
1149: AND d.PLAN_ID = planId

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

1192: --dbms_output.put_line(planId);
1193:
1194: -- is this only one result ????? or more ???
1195: select d.INVENTORY_ITEM_ID, d.SOURCE_ORGANIZATION_ID into invItemId, orgId
1196: FROM MSC_DEMANDS d, MSC_DELIVERY_DETAILS dd, MSC_TRANSPORTATION_UPDATES tu
1197: WHERE d.SALES_ORDER_LINE_ID = dd.SOURCE_LINE_ID
1198: AND d.SR_INSTANCE_ID = dd.SR_INSTANCE_ID
1199: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
1200: AND dd.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 1226: UPDATE MSC_DEMANDS

1222: --Update all ISOs
1223: i:=1;
1224: FOR i IN 1 .. ISO_Ids.COUNT
1225: LOOP
1226: UPDATE MSC_DEMANDS
1227: Set OTM_ARRIVAL_DATE = newArrivalDate,
1228: LAST_UPDATE_DATE = SYSDATE,
1229: LAST_UPDATED_BY = userId
1230: WHERE PLAN_ID = planId