275: )
276: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
277: ldets.price_adjustment_id
278: , sysdate --p_Line_Adj_rec.creation_date
279: , fnd_global.user_id --p_Line_Adj_rec.created_by
280: , sysdate --p_Line_Adj_rec.last_update_date
281: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
282: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
283: , NULL --p_Line_Adj_rec.program_application_id
277: ldets.price_adjustment_id
278: , sysdate --p_Line_Adj_rec.creation_date
279: , fnd_global.user_id --p_Line_Adj_rec.created_by
280: , sysdate --p_Line_Adj_rec.last_update_date
281: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
282: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
283: , NULL --p_Line_Adj_rec.program_application_id
284: , NULL --p_Line_Adj_rec.program_id
285: , NULL --p_Line_Adj_rec.program_update_date
278: , sysdate --p_Line_Adj_rec.creation_date
279: , fnd_global.user_id --p_Line_Adj_rec.created_by
280: , sysdate --p_Line_Adj_rec.last_update_date
281: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
282: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
283: , NULL --p_Line_Adj_rec.program_application_id
284: , NULL --p_Line_Adj_rec.program_id
285: , NULL --p_Line_Adj_rec.program_update_date
286: , NULL --p_Line_Adj_rec.request_id
418: )
419: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
420: LDET.price_adjustment_id
421: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
422: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
423: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
424: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
425: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
426: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
420: LDET.price_adjustment_id
421: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
422: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
423: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
424: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
425: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
426: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
427: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
428: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
421: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
422: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
423: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
424: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
425: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
426: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
427: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
428: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
429: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
487: (SELECT LDETS.PRICE_ADJUSTMENT_ID
488: ,QPLAT.CONTEXT
489: ,QPLAT.ATTRIBUTE
490: ,sysdate
491: ,fnd_global.user_id
492: ,sysdate
493: ,fnd_global.user_id
494: ,fnd_global.login_id
495: ,NULL
489: ,QPLAT.ATTRIBUTE
490: ,sysdate
491: ,fnd_global.user_id
492: ,sysdate
493: ,fnd_global.user_id
494: ,fnd_global.login_id
495: ,NULL
496: ,NULL
497: ,NULL
490: ,sysdate
491: ,fnd_global.user_id
492: ,sysdate
493: ,fnd_global.user_id
494: ,fnd_global.login_id
495: ,NULL
496: ,NULL
497: ,NULL
498: ,NULL