APPS.OEXVWCAN dependencies on SO_LINES

Line 30: FROM SO_LINES

26: LINE_NUMBER
27: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
28: V_PARENT_LINE_ID,
29: V_LINE_NUMBER
30: FROM SO_LINES
31: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
32: END IF;
33: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NOT NULL) THEN
34: IF (V_PARENT_LINE_ID IS NULL) THEN

Line 39: FROM SO_LINES

35: SCHEDULE_LINE_NUMBER := V_LINE_NUMBER;
36: ELSE
37: SELECT LINE_NUMBER
38: INTO SCHEDULE_LINE_NUMBER
39: FROM SO_LINES
40: WHERE LINE_ID = V_PARENT_LINE_ID;
41: END IF;
42: END IF;
43:

Line 79: FROM SO_LINES

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

Line 88: FROM SO_LINES

84: BASE_LINE_NUMBER := V_LINE_NUMBER;
85: ELSE
86: SELECT LINE_NUMBER
87: INTO BASE_LINE_NUMBER
88: FROM SO_LINES
89: WHERE LINE_ID = V_PARENT_LINE_ID;
90: END IF;
91: ELSE
92: SELECT LINE_NUMBER

Line 94: FROM SO_LINES

90: END IF;
91: ELSE
92: SELECT LINE_NUMBER
93: INTO BASE_LINE_NUMBER
94: FROM SO_LINES
95: WHERE LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID;
96: END IF;
97:
98: RETURN(BASE_LINE_NUMBER);

Line 132: FROM SO_LINES

128: LINE_NUMBER
129: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
130: V_PARENT_LINE_ID,
131: V_LINE_NUMBER
132: FROM SO_LINES
133: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
134: END IF;
135: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NULL) THEN
136: IF (V_PARENT_LINE_ID IS NOT NULL) THEN

Line 168: FROM SO_LINES

164: BEGIN
165:
166: SELECT 'Y'
167: INTO V_SUBTREE_EXISTS
168: FROM SO_LINES
169: WHERE LINK_TO_LINE_ID = V_LINE_ID
170: AND PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
171: AND ITEM_TYPE_CODE <> 'SERVICE'
172: AND LINE_TYPE_CODE <> 'RETURN'

Line 215: FROM SO_LINES

211: RESULT := 'N';
212: ELSE
213: SELECT ITEM_TYPE_CODE
214: INTO TEMP_ITEM_TYPE_CODE
215: FROM SO_LINES
216: WHERE LINE_ID = V_SERVICE_PARENT_LINE_ID;
217:
218: IF (TEMP_ITEM_TYPE_CODE = 'MODEL') THEN
219: RESULT := 'Y';

Line 258: FROM SO_LINES

254: SO_PICKING_HEADERS SPH
255: WHERE SOL.PICKING_HEADER_ID = SPH.PICKING_HEADER_ID
256: AND SOL.ORDER_LINE_ID in
257: (SELECT LINE_ID
258: FROM SO_LINES
259: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
260: AND NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE || '%'
261: AND V_SUBTREE_EXISTS = 'Y'
262: UNION

Line 264: FROM SO_LINES

260: AND NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE || '%'
261: AND V_SUBTREE_EXISTS = 'Y'
262: UNION
263: SELECT LINE_ID
264: FROM SO_LINES
265: WHERE LINE_ID = V_LINE_ID)
266: AND SPH.STATUS_CODE IN ('OPEN' ,'PENDING', 'IN PROGRESS')
267: AND ROWNUM = 1;
268:

Line 322: FROM SO_LINES

318: BEGIN
319:
320: SELECT COMPONENT_SEQUENCE_ID
321: INTO V_TOP_BILL_SEQUENCE_ID
322: FROM SO_LINES
323: WHERE LINE_ID = NVL(V_PARENT_LINE_ID,V_LINE_ID);
324:
325: RETURN(V_TOP_BILL_SEQUENCE_ID);
326: