APPS.ONT_UPGRADE_EXCEPTION_REPORT dependencies on SO_LINES_ALL

Line 27: FROM SO_LINES_ALL

23: LINE_NUMBER
24: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
25: V_PARENT_LINE_ID,
26: V_LINE_NUMBER
27: FROM SO_LINES_ALL
28: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
29: END IF;
30: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NULL) THEN
31: IF (V_PARENT_LINE_ID IS NULL) THEN

Line 36: FROM SO_LINES_ALL

32: BASE_LINE_NUMBER := V_LINE_NUMBER;
33: ELSE
34: SELECT LINE_NUMBER
35: INTO BASE_LINE_NUMBER
36: FROM SO_LINES_ALL
37: WHERE LINE_ID = V_PARENT_LINE_ID;
38: END IF;
39: ELSE
40: SELECT LINE_NUMBER

Line 42: FROM SO_LINES_ALL

38: END IF;
39: ELSE
40: SELECT LINE_NUMBER
41: INTO BASE_LINE_NUMBER
42: FROM SO_LINES_ALL
43: WHERE LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID;
44: END IF;
45:
46: RETURN(BASE_LINE_NUMBER);

Line 78: FROM SO_LINES_ALL

74: LINE_NUMBER
75: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
76: V_PARENT_LINE_ID,
77: V_LINE_NUMBER
78: FROM SO_LINES_ALL
79: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
80: END IF;
81: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NOT NULL) THEN
82: IF (V_PARENT_LINE_ID IS NULL) THEN

Line 87: FROM SO_LINES_ALL

83: SCHEDULE_LINE_NUMBER := V_LINE_NUMBER;
84: ELSE
85: SELECT LINE_NUMBER
86: INTO SCHEDULE_LINE_NUMBER
87: FROM SO_LINES_ALL
88: WHERE LINE_ID = V_PARENT_LINE_ID;
89: END IF;
90: END IF;
91:

Line 124: FROM SO_LINES_ALL

120: LINE_NUMBER
121: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
122: V_PARENT_LINE_ID,
123: V_LINE_NUMBER
124: FROM SO_LINES_ALL
125: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
126: END IF;
127: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NULL) THEN
128: IF (V_PARENT_LINE_ID IS NOT NULL) THEN