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.OE_RMA_LINE_VALIDATE dependencies on SO_PRICE_ADJUSTMENTS

Line 228: INSERT INTO SO_PRICE_ADJUSTMENTS

224: FROM SO_SALES_CREDITS
225: WHERE SO_SALES_CREDITS.LINE_ID = L_LINK_TO_LINE_ID;
226:
227:
228: INSERT INTO SO_PRICE_ADJUSTMENTS
229: ( PRICE_ADJUSTMENT_ID
230: , CREATION_DATE
231: , CREATED_BY
232: , LAST_UPDATE_DATE

Line 258: SELECT SO_PRICE_ADJUSTMENTS_S.NEXTVAL

254: , ATTRIBUTE14
255: , ATTRIBUTE15
256: , CONTEXT
257: )
258: SELECT SO_PRICE_ADJUSTMENTS_S.NEXTVAL
259: , SYSDATE
260: , L_USER_ID
261: , SYSDATE
262: , L_USER_ID

Line 265: , SO_PRICE_ADJUSTMENTS.DISCOUNT_ID

261: , SYSDATE
262: , L_USER_ID
263: , L_LOGIN_ID
264: , L_HEADER_ID
265: , SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID

Line 266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID

262: , L_USER_ID
263: , L_LOGIN_ID
264: , L_HEADER_ID
265: , SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1

Line 267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG

263: , L_LOGIN_ID
264: , L_HEADER_ID
265: , SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2

Line 268: , SO_PRICE_ADJUSTMENTS.PERCENT

264: , L_HEADER_ID
265: , SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3

Line 270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1

266: , SO_PRICE_ADJUSTMENTS.DISCOUNT_LINE_ID
267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5

Line 271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2

267: , SO_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG
268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6

Line 272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3

268: , SO_PRICE_ADJUSTMENTS.PERCENT
269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7

Line 273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4

269: , L_LINE_ID
270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8

Line 274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5

270: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE1
271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9

Line 275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6

271: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE2
272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10

Line 276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7

272: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE3
273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11

Line 277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8

273: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE4
274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12

Line 278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9

274: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE5
275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13

Line 279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10

275: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE6
276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14

Line 280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11

276: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE7
277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15

Line 281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12

277: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE8
278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT

Line 282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13

278: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE9
279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS

Line 283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14

279: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE10
280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID

Line 284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15

280: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE11
281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =

Line 285: , SO_PRICE_ADJUSTMENTS.CONTEXT

281: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE12
282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID

Line 286: FROM SO_PRICE_ADJUSTMENTS

282: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE13
283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'

Line 287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID

283: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE14
284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'
291: FROM SO_PRICE_ADJUSTMENTS SPA

Line 288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =

284: , SO_PRICE_ADJUSTMENTS.ATTRIBUTE15
285: , SO_PRICE_ADJUSTMENTS.CONTEXT
286: FROM SO_PRICE_ADJUSTMENTS
287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'
291: FROM SO_PRICE_ADJUSTMENTS SPA
292: WHERE SPA.DISCOUNT_ID = SO_PRICE_ADJUSTMENTS.DISCOUNT_ID

Line 291: FROM SO_PRICE_ADJUSTMENTS SPA

287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'
291: FROM SO_PRICE_ADJUSTMENTS SPA
292: WHERE SPA.DISCOUNT_ID = SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
293: AND SPA.HEADER_ID = L_HEADER_ID
294: AND SPA.LINE_ID IS NULL);
295:

Line 292: WHERE SPA.DISCOUNT_ID = SO_PRICE_ADJUSTMENTS.DISCOUNT_ID

288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'
291: FROM SO_PRICE_ADJUSTMENTS SPA
292: WHERE SPA.DISCOUNT_ID = SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
293: AND SPA.HEADER_ID = L_HEADER_ID
294: AND SPA.LINE_ID IS NULL);
295:
296: END IF;