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_TRANSPORTATION_UPDATES

Line 100: MSC_transportation_updates

96: cursor getLineIds is
97: SELECT
98: po_line_location_id , UPDATED_ARRIVAL_DATE
99: FROM
100: MSC_transportation_updates
101: WHERE order_type = 1;
102:
103: v_line_location_id NUMBER :=0;
104: v_arrival_Date DATE;

Line 135: FROM MSC_transportation_updates

131: AppsInit;
132:
133: SELECT po_line_location_id , UPDATED_ARRIVAL_DATE
134: INTO v_line_location_id, v_arrival_Date
135: FROM MSC_transportation_updates
136: WHERE order_type = 1
137: AND trans_Update_id = tranzId;
138:
139: Update_CP(v_line_location_id,v_arrival_Date, status );

Line 345: MSC_TRANSPORTATION_UPDATES;

341: cursor c_getLineIds is
342: SELECT
343: order_type, TRANS_UPDATE_ID
344: FROM
345: MSC_TRANSPORTATION_UPDATES;
346:
347: v_order_type NUMBER :=0;
348: v_id NUMBER :=0;
349: plan_id NUMBER :=0;

Line 510: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

506: s.new_dock_date, s.order_number,
507: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID, s.SOURCE_ORGANIZATION_ID
508: INTO supp_Transaction_id, newArrivalDate, srInstanceId, v_org_id, v_inv_item_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_q,
509: v_source_sr_inst_id, v_sr_org_id
510: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
511: WHERE s.ORDER_TYPE = 11
512: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
513: AND s.SUPPLIER_ID is not null
514: AND s.PLAN_ID = planId

Line 525: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

521: s.supplier_site_id, s.new_dock_date, s.order_number,
522: s.NEW_ORDER_QUANTITY, s.SOURCE_SR_INSTANCE_ID,s.SOURCE_ORGANIZATION_ID
523: INTO supp_Transaction_id, newArrivalDate, srInstanceId, v_org_id, v_inv_item_id, v_supplier_id, v_supplier_site_id, v_old_dock_date, v_order_number, v_q,
524: v_source_sr_inst_id, v_sr_org_id
525: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
526: WHERE s.ORDER_TYPE = 1
527: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
528: AND s.PO_LINE_ID = tu.PO_LINE_ID
529: AND s.PLAN_ID =planId

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 687: from msc_transportation_updates

683: -- IF I NEED TO PUT TRANSACTION_ID, I NEED TO GENERATE ONE EXCEPTION FOR EACH ROW !! IF NOT, JUST ONE EXC PER LINE ITEM
684: begin
685:
686: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
687: from msc_transportation_updates
688: where TRANS_UPDATE_ID = transId;
689:
690: SELECT distinct d.DEMAND_ID
691: INTO ISOID1

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 846: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

842: status out nocopy varchar2) IS
843:
844: cursor GetPOIds is
845: SELECT s.TRANSACTION_ID
846: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
847: WHERE s.ORDER_TYPE = 1
848: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
849: AND s.PO_LINE_ID = tu.PO_LINE_ID
850: AND s.PLAN_ID =planId

Line 856: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

852: AND tu.TRANS_UPDATE_ID = transId;
853:
854: cursor GetPOShipmentIds is
855: SELECT s.TRANSACTION_ID
856: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
857: WHERE s.ORDER_TYPE = 11
858: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
859: AND s.SUPPLIER_ID is not null
860: AND s.PLAN_ID = planId

Line 878: from msc_transportation_updates

874: userId NUMBER :=0;
875: begin
876:
877: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
878: from msc_transportation_updates
879: where TRANS_UPDATE_ID = transId;
880:
881: --- Get PO_Ids
882: i:=1;

Line 896: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

892:
893: if ( i = 1) then -- PO shipment, not PO
894: isPoShipment := 1;
895: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
896: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
897: WHERE s.ORDER_TYPE = 11
898: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
899: AND s.PLAN_ID =planId
900: AND s.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID

Line 906: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu

902:
903: else
904: isPoShipment := 0;
905: select distinct s.INVENTORY_ITEM_ID, s.ORGANIZATION_ID into invItemId, orgId
906: FROM MSC_SUPPLIES s, MSC_TRANSPORTATION_UPDATES tu
907: WHERE s.ORDER_TYPE = 1
908: AND s.PO_LINE_LOCATION_ID = tu.PO_LINE_LOCATION_ID
909: AND s.PO_LINE_ID = tu.PO_LINE_ID
910: AND s.PLAN_ID =planId

Line 943: UPDATE msc_transportation_updates

939: --userId := fnd_global.User_id();
940: userId := g_UserId;
941: --dbms_output.put_line('got leadTime' || v_new_firm_date);
942:
943: UPDATE msc_transportation_updates
944: SET UPDATED_DUE_DATE = v_new_firm_Date,
945: LAST_UPDATE_DATE = SYSDATE,
946: LAST_UPDATED_BY = userId
947: WHERE TRANS_UPDATE_ID = transId;

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 1016: from msc_transportation_updates

1012:
1013: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));
1014:
1015: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
1016: from msc_transportation_updates
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

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 1090: UPDATE msc_transportation_updates

1086: if ( GetLeadTime(invItemId, orgId, planId, SrInstanceId, newArrivalDate, v_new_firm_Date) = false) then
1087: v_new_firm_Date := newArrivalDate;
1088: end if;
1089:
1090: UPDATE msc_transportation_updates
1091: SET UPDATED_DUE_DATE = v_new_firm_Date,
1092: LAST_UPDATE_DATE = SYSDATE,
1093: LAST_UPDATED_BY = userId
1094: WHERE TRANS_UPDATE_ID = transId;

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 1189: from msc_transportation_updates

1185:
1186:
1187:
1188: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
1189: from msc_transportation_updates
1190: where TRANS_UPDATE_ID = transId;
1191:
1192: --dbms_output.put_line(planId);
1193:

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 1273: UPDATE msc_transportation_updates

1269: if ( GetLeadTime(invItemId, orgId, planId, SrInstanceId, newArrivalDate, v_new_firm_Date) = false) then
1270: v_new_firm_Date := newArrivalDate;
1271: end if;
1272:
1273: UPDATE msc_transportation_updates
1274: SET UPDATED_DUE_DATE = v_new_firm_Date,
1275: LAST_UPDATE_DATE = SYSDATE,
1276: LAST_UPDATED_BY = userId
1277: WHERE TRANS_UPDATE_ID = transId;

Line 1384: from MSC_TRANSPORTATION_UPDATES

1380: --dbms_output.put_line('d1 = ' || d1);
1381: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1382:
1383: select count(1) into nCount
1384: from MSC_TRANSPORTATION_UPDATES
1385: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1386:
1387: if ( nCount =0 ) then
1388:

Line 1389: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;

1385: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1386:
1387: if ( nCount =0 ) then
1388:
1389: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1390:
1391: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, PO_LINE_LOCATION_ID, PO_LINE_ID, UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID,
1392: OTM_RELEASE_GID, OTM_RELEASE_LINE_GID,
1393: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)

Line 1391: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, PO_LINE_LOCATION_ID, PO_LINE_ID, UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID,

1387: if ( nCount =0 ) then
1388:
1389: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1390:
1391: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, PO_LINE_LOCATION_ID, PO_LINE_ID, UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID,
1392: OTM_RELEASE_GID, OTM_RELEASE_LINE_GID,
1393: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
1394: VALUES (key, 1, locationLineId,poId, d1, srInstanceId,
1395: ReleaseGid, ReleaseLineGid, SYSDATE, userId, SYSDATE, userId);

Line 1400: update MSC_TRANSPORTATION_UPDATES

1396:
1397: status:= 'SUCCESS';
1398: tranzId := key;
1399: else
1400: update MSC_TRANSPORTATION_UPDATES
1401: set UPDATED_ARRIVAL_DATE = d1,
1402: LAST_UPDATE_DATE = SYSDATE,
1403: LAST_UPDATED_BY = userId
1404: where OTM_RELEASE_LINE_GID = ReleaseLineGid;

Line 1407: from msc_transportation_updates

1403: LAST_UPDATED_BY = userId
1404: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1405:
1406: select trans_update_id into tranzId
1407: from msc_transportation_updates
1408: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1409:
1410: status:= 'SUCCESS';
1411: end if;

Line 1449: from MSC_TRANSPORTATION_UPDATES

1445: d1 := to_date(pnewArrivalDate, 'YYYY/MM/DD HH24:MI:SS');
1446:
1447:
1448: select count(1) into nCount
1449: from MSC_TRANSPORTATION_UPDATES
1450: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1451:
1452: --dbms_output.put_line('count = '|| nCount);
1453: --dbms_output.put_line('ReleaseLineGid = '|| '<' || ReleaseLineGid || '>');

Line 1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;

1454:
1455: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1456:
1457: if ( nCount =0 ) then
1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1459:
1460: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, UPDATED_ARRIVAL_DATE,EBS_SR_INSTANCE_ID,
1461: OTM_RELEASE_GID,OTM_RELEASE_LINE_GID,WSH_DELIVERY_DETAIL_ID,
1462: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)

Line 1460: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, UPDATED_ARRIVAL_DATE,EBS_SR_INSTANCE_ID,

1456:
1457: if ( nCount =0 ) then
1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1459:
1460: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, UPDATED_ARRIVAL_DATE,EBS_SR_INSTANCE_ID,
1461: OTM_RELEASE_GID,OTM_RELEASE_LINE_GID,WSH_DELIVERY_DETAIL_ID,
1462: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
1463: VALUES (key, 2, d1, srInstanceId, ReleaseGid, ReleaseLineGid, ReleaseLineGid, SYSDATE, userId, SYSDATE, userId);
1464:

Line 1468: update MSC_TRANSPORTATION_UPDATES

1464:
1465: status:= 'SUCCESS';
1466: tranzId := key;
1467: else
1468: update MSC_TRANSPORTATION_UPDATES
1469: set UPDATED_ARRIVAL_DATE = d1,
1470: LAST_UPDATE_DATE = SYSDATE,
1471: LAST_UPDATED_BY = userId
1472: where OTM_RELEASE_LINE_GID = ReleaseLineGid;

Line 1475: from msc_transportation_updates

1471: LAST_UPDATED_BY = userId
1472: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1473:
1474: select trans_update_id into tranzId
1475: from msc_transportation_updates
1476: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1477:
1478: status:= 'SUCCESS';
1479:

Line 1533: from msc_transportation_updates

1529: tokenValues := MsgTokenValuePairList();
1530:
1531: select order_type , EBS_SR_INSTANCE_ID, OTM_RELEASE_GID, updated_Arrival_Date
1532: into v_order_type, v_srInstanceId, otmReleaseGid, v_arrival_Date
1533: from msc_transportation_updates
1534: where trans_update_id = tranzId;
1535:
1536: v_Http := GetPunchoutURI( 0, otmReleaseGid);
1537: --dbms_output.put_line(v_Http);

Line 1543: FROM MSC_TRANSPORTATION_UPDATES

1539: -- order number needed, that is different for PO and SO.
1540: if (v_order_type = 1) then
1541: SELECT po_line_location_id
1542: INTO v_line_location_id
1543: FROM MSC_TRANSPORTATION_UPDATES
1544: WHERE trans_update_id = tranzId;
1545:
1546: GetDataForNotification( v_line_location_id, v_srInstanceId, v_orderNumber, v_itemId, v_orgId);
1547: --dbms_output.put_line(v_itemId || ' ' || v_orderNumber );

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

Line 1691: MSC_TRANSPORTATION_UPDATES;

1687: cursor c_getLine is
1688: SELECT
1689: TRANS_UPDATE_ID, updated_Due_Date
1690: FROM
1691: MSC_TRANSPORTATION_UPDATES;
1692:
1693: v_trans_id NUMBER :=0;
1694: v_due_Date DATE;
1695: v_adj_date DATE;

Line 1707: delete from msc_transportation_updates where trans_update_id = v_trans_id;

1703: EXIT WHEN c_getLine%NOTFOUND;
1704: v_adj_date := v_due_Date + 90;
1705: --dbms_output.put_line(v_adj_date);
1706: if ( v_adj_Date < SYSDATE ) then
1707: delete from msc_transportation_updates where trans_update_id = v_trans_id;
1708: end if;
1709:
1710: END LOOP;
1711: CLOSE c_getLine;