3463: , decode(lines.parent_price, NULL, 0, 0, 0,
3464: lines.adjusted_unit_price/lines.parent_price)
3465: , l.lock_control + 1
3466: , SYSDATE
3467: , FND_GLOBAL.USER_ID
3468: , FND_GLOBAL.LOGIN_ID
3469: from qp_preq_lines_tmp lines
3470: where lines.line_id=l.line_id
3471: and l.open_flag <> 'N'
3464: lines.adjusted_unit_price/lines.parent_price)
3465: , l.lock_control + 1
3466: , SYSDATE
3467: , FND_GLOBAL.USER_ID
3468: , FND_GLOBAL.LOGIN_ID
3469: from qp_preq_lines_tmp lines
3470: where lines.line_id=l.line_id
3471: and l.open_flag <> 'N'
3472: and lines.line_type_code='LINE'
4041: , adj.lock_control + 1
4042: --bug#7369643
4043: --This code is added to update the last update information in who columns
4044: , sysdate
4045: , fnd_global.user_id
4046: , fnd_global.LOGIN_ID
4047: --bug#7369643
4048: from
4049: QP_LDETS_v ldets
4042: --bug#7369643
4043: --This code is added to update the last update information in who columns
4044: , sysdate
4045: , fnd_global.user_id
4046: , fnd_global.LOGIN_ID
4047: --bug#7369643
4048: from
4049: QP_LDETS_v ldets
4050: where ldets.line_detail_index = p_line_detail_index
4474: )
4475: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
4476: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
4477: , sysdate --p_Line_Adj_rec.creation_date
4478: , fnd_global.user_id --p_Line_Adj_rec.created_by
4479: , sysdate --p_Line_Adj_rec.last_update_date
4480: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4481: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4482: , NULL --p_Line_Adj_rec.program_application_id
4476: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
4477: , sysdate --p_Line_Adj_rec.creation_date
4478: , fnd_global.user_id --p_Line_Adj_rec.created_by
4479: , sysdate --p_Line_Adj_rec.last_update_date
4480: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4481: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4482: , NULL --p_Line_Adj_rec.program_application_id
4483: , NULL --p_Line_Adj_rec.program_id
4484: , NULL --p_Line_Adj_rec.program_update_date
4477: , sysdate --p_Line_Adj_rec.creation_date
4478: , fnd_global.user_id --p_Line_Adj_rec.created_by
4479: , sysdate --p_Line_Adj_rec.last_update_date
4480: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4481: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4482: , NULL --p_Line_Adj_rec.program_application_id
4483: , NULL --p_Line_Adj_rec.program_id
4484: , NULL --p_Line_Adj_rec.program_update_date
4485: , NULL --p_Line_Adj_rec.request_id
4620: )
4621: (SELECT *+ ORDERED USE_NL(ADJ RADJ) *
4622: adj.price_adjustment_id
4623: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4624: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4625: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4626: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4627: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4628: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4622: adj.price_adjustment_id
4623: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4624: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4625: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4626: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4627: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4628: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4629: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4630: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4623: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4624: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4625: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4626: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4627: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4628: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4629: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4630: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4631: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4666: )
4667: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
4668: adj.price_adjustment_id
4669: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4670: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4671: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4672: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4673: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4674: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4668: adj.price_adjustment_id
4669: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4670: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4671: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4672: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4673: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4674: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4675: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4676: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4669: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4670: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4671: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4672: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4673: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4674: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4675: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4676: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4677: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4767: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4768: ,QPLAT.CONTEXT
4769: ,QPLAT.ATTRIBUTE
4770: ,sysdate
4771: ,fnd_global.user_id
4772: ,sysdate
4773: ,fnd_global.user_id
4774: ,fnd_global.login_id
4775: ,NULL
4769: ,QPLAT.ATTRIBUTE
4770: ,sysdate
4771: ,fnd_global.user_id
4772: ,sysdate
4773: ,fnd_global.user_id
4774: ,fnd_global.login_id
4775: ,NULL
4776: ,NULL
4777: ,NULL
4770: ,sysdate
4771: ,fnd_global.user_id
4772: ,sysdate
4773: ,fnd_global.user_id
4774: ,fnd_global.login_id
4775: ,NULL
4776: ,NULL
4777: ,NULL
4778: ,NULL
4873: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4874: ,QPLAT.CONTEXT
4875: ,QPLAT.ATTRIBUTE
4876: ,sysdate
4877: ,fnd_global.user_id
4878: ,sysdate
4879: ,fnd_global.user_id
4880: ,fnd_global.login_id
4881: ,NULL
4875: ,QPLAT.ATTRIBUTE
4876: ,sysdate
4877: ,fnd_global.user_id
4878: ,sysdate
4879: ,fnd_global.user_id
4880: ,fnd_global.login_id
4881: ,NULL
4882: ,NULL
4883: ,NULL
4876: ,sysdate
4877: ,fnd_global.user_id
4878: ,sysdate
4879: ,fnd_global.user_id
4880: ,fnd_global.login_id
4881: ,NULL
4882: ,NULL
4883: ,NULL
4884: ,NULL
4967: (SELECT ADJ.PRICE_ADJUSTMENT_ID
4968: ,QPLAT.CONTEXT
4969: ,QPLAT.ATTRIBUTE
4970: ,sysdate
4971: ,fnd_global.user_id
4972: ,sysdate
4973: ,fnd_global.user_id
4974: ,fnd_global.login_id
4975: ,NULL
4969: ,QPLAT.ATTRIBUTE
4970: ,sysdate
4971: ,fnd_global.user_id
4972: ,sysdate
4973: ,fnd_global.user_id
4974: ,fnd_global.login_id
4975: ,NULL
4976: ,NULL
4977: ,NULL
4970: ,sysdate
4971: ,fnd_global.user_id
4972: ,sysdate
4973: ,fnd_global.user_id
4974: ,fnd_global.login_id
4975: ,NULL
4976: ,NULL
4977: ,NULL
4978: ,NULL
5026: (SELECT ADJ.PRICE_ADJUSTMENT_ID
5027: ,QPLAT.CONTEXT
5028: ,QPLAT.ATTRIBUTE
5029: ,sysdate
5030: ,fnd_global.user_id
5031: ,sysdate
5032: ,fnd_global.user_id
5033: ,fnd_global.login_id
5034: ,NULL
5028: ,QPLAT.ATTRIBUTE
5029: ,sysdate
5030: ,fnd_global.user_id
5031: ,sysdate
5032: ,fnd_global.user_id
5033: ,fnd_global.login_id
5034: ,NULL
5035: ,NULL
5036: ,NULL
5029: ,sysdate
5030: ,fnd_global.user_id
5031: ,sysdate
5032: ,fnd_global.user_id
5033: ,fnd_global.login_id
5034: ,NULL
5035: ,NULL
5036: ,NULL
5037: ,NULL
5086: ADJ.PRICE_ADJUSTMENT_ID
5087: ,QPLAT.CONTEXT
5088: ,QPLAT.ATTRIBUTE
5089: ,sysdate
5090: ,fnd_global.user_id
5091: ,sysdate
5092: ,fnd_global.user_id
5093: ,fnd_global.login_id
5094: ,NULL
5088: ,QPLAT.ATTRIBUTE
5089: ,sysdate
5090: ,fnd_global.user_id
5091: ,sysdate
5092: ,fnd_global.user_id
5093: ,fnd_global.login_id
5094: ,NULL
5095: ,NULL
5096: ,NULL
5089: ,sysdate
5090: ,fnd_global.user_id
5091: ,sysdate
5092: ,fnd_global.user_id
5093: ,fnd_global.login_id
5094: ,NULL
5095: ,NULL
5096: ,NULL
5097: ,NULL