APPS.MSC_WS_OTM_BPEL dependencies on MSC_SALES_ORDERS

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