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