DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on FND_GLOBAL

Line 3467: , FND_GLOBAL.USER_ID

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'

Line 3468: , FND_GLOBAL.LOGIN_ID

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'

Line 4045: , fnd_global.user_id

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

Line 4046: , fnd_global.LOGIN_ID

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

Line 4478: , fnd_global.user_id --p_Line_Adj_rec.created_by

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

Line 4480: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

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

Line 4481: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

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

Line 4624: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY

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

Line 4626: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY

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

Line 4627: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN

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

Line 4670: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY

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

Line 4672: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY

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

Line 4673: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN

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

Line 4771: ,fnd_global.user_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

Line 4773: ,fnd_global.user_id

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

Line 4774: ,fnd_global.login_id

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

Line 4877: ,fnd_global.user_id

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

Line 4879: ,fnd_global.user_id

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

Line 4880: ,fnd_global.login_id

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

Line 4971: ,fnd_global.user_id

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

Line 4973: ,fnd_global.user_id

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

Line 4974: ,fnd_global.login_id

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

Line 5030: ,fnd_global.user_id

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

Line 5032: ,fnd_global.user_id

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

Line 5033: ,fnd_global.login_id

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

Line 5090: ,fnd_global.user_id

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

Line 5092: ,fnd_global.user_id

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

Line 5093: ,fnd_global.login_id

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