[Home] [Help]
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
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
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
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