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_DELIVERY_DETAILS

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 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 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 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 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 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 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 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 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