APPS.OEXVWLIN dependencies on SO_LINES

Line 41: FROM SO_LINES

37: NVL( CANCELLED_QUANTITY, 0 )) *
38: NVL(SELLING_PRICE, 0 ))
39: , 0)
40: INTO order_line_total
41: FROM SO_LINES
42: WHERE SHIPMENT_SCHEDULE_LINE_ID = ORDER_LINE_ID;
43: elsif ( ITEM_TYPE_CODE = 'MODEL' )
44: then
45: SELECT NVL(SUM((NVL( ORDERED_QUANTITY, 0 ) -

Line 50: FROM SO_LINES

46: NVL( CANCELLED_QUANTITY, 0 )) *
47: NVL(SELLING_PRICE, 0 ))
48: , 0)
49: INTO order_line_total
50: FROM SO_LINES
51: WHERE (ROWID = ORDER_ROWID
52: OR PARENT_LINE_ID = ORDER_LINE_ID
53: OR SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );
54: elsif (ITEM_TYPE_CODE = 'SERVICE')

Line 70: FROM SO_LINES

66: NVL( CANCELLED_QUANTITY, 0 )) *
67: NVL(SELLING_PRICE, 0 ))
68: , 0)
69: INTO order_line_total
70: FROM SO_LINES
71: WHERE (ROWID = ORDER_ROWID
72: OR SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );
73: else
74: order_line_total := ( ORDERED_QTY - CANCELLED_QTY)

Line 207: FROM SO_LINES

203: SHIP_NUMBER := ORDER_LINE_NUMBER;
204: ELSE
205: SELECT LINE_NUMBER
206: INTO SHIP_NUMBER
207: FROM SO_LINES
208: WHERE LINE_ID = ORDER_PARENT_LINE_ID;
209: END IF;
210: END IF;
211:

Line 241: FROM SO_LINES

237: LINES_NUMBER := ORDER_LINE_NUMBER ;
238: ELSE
239: SELECT LINE_NUMBER
240: INTO LINES_NUMBER
241: FROM SO_LINES
242: WHERE LINE_ID = ORDER_PARENT_LINE_ID;
243: END IF;
244: ELSE
245: SELECT LINE_NUMBER

Line 247: FROM SO_LINES

243: END IF;
244: ELSE
245: SELECT LINE_NUMBER
246: INTO LINES_NUMBER
247: FROM SO_LINES
248: WHERE LINE_ID = ORDER_SHIP_SCHEDULE_LINE_ID;
249: END IF;
250:
251: RETURN( LINES_NUMBER);