APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_TRANSPORTATION

Line 1032: FROM MSC_INT_ASCP_TRANSPORTATION

1028: TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,
1029: ItemID,
1030: 1,
1031: SYSDATE, '-1', SYSDATE, '-1'
1032: FROM MSC_INT_ASCP_TRANSPORTATION
1033: WHERE PLAN_ID=PlanIdVar;
1034: EXCEPTION WHEN others THEN
1035: g_ErrorCode := 'ERROR_UPDATE_DEMAND_FROM_ASCP_TRANSPORTATION_001003';
1036: raise;

Line 1108: -- Fill in data from MSC_INT_ASCP_TRANSPORTATION

1104:
1105: BEGIN
1106: -- CODE GOES HERE
1107: --
1108: -- Fill in data from MSC_INT_ASCP_TRANSPORTATION
1109: --
1110: INSERT INTO MSC_SUPPLIES (
1111: PLAN_ID,
1112: TRANSACTION_ID,

Line 1141: FROM MSC_INT_ASCP_TRANSPORTATION

1137: fromOrgID,
1138: fromInstanceID,
1139: transportMode,
1140: SYSDATE, '-1', SYSDATE, '-1'
1141: FROM MSC_INT_ASCP_TRANSPORTATION
1142: WHERE PLAN_ID=PlanIdVar;
1143: EXCEPTION WHEN others THEN
1144: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_ASCP_TRANSPORTATION_001002';
1145: raise;