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.

[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on FND_GLOBAL

Line 3397: , FND_GLOBAL.USER_ID

3393: , decode(lines.parent_price, NULL, 0, 0, 0,
3394: lines.adjusted_unit_price/lines.parent_price)
3395: , l.lock_control + 1
3396: , SYSDATE
3397: , FND_GLOBAL.USER_ID
3398: , FND_GLOBAL.LOGIN_ID
3399: from qp_preq_lines_tmp lines
3400: where lines.line_id=l.line_id
3401: and l.open_flag <> 'N'

Line 3398: , FND_GLOBAL.LOGIN_ID

3394: lines.adjusted_unit_price/lines.parent_price)
3395: , l.lock_control + 1
3396: , SYSDATE
3397: , FND_GLOBAL.USER_ID
3398: , FND_GLOBAL.LOGIN_ID
3399: from qp_preq_lines_tmp lines
3400: where lines.line_id=l.line_id
3401: and l.open_flag <> 'N'
3402: and lines.line_type_code='LINE'

Line 3930: , fnd_global.user_id

3926: , adj.lock_control + 1
3927: --bug#7369643
3928: --This code is added to update the last update information in who columns
3929: , sysdate
3930: , fnd_global.user_id
3931: , fnd_global.LOGIN_ID
3932: --bug#7369643
3933: from
3934: QP_LDETS_v ldets

Line 3931: , fnd_global.LOGIN_ID

3927: --bug#7369643
3928: --This code is added to update the last update information in who columns
3929: , sysdate
3930: , fnd_global.user_id
3931: , fnd_global.LOGIN_ID
3932: --bug#7369643
3933: from
3934: QP_LDETS_v ldets
3935: where ldets.line_detail_index = p_line_detail_index

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

4359: )
4360: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
4361: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
4362: , sysdate --p_Line_Adj_rec.creation_date
4363: , fnd_global.user_id --p_Line_Adj_rec.created_by
4364: , sysdate --p_Line_Adj_rec.last_update_date
4365: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4366: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4367: , NULL --p_Line_Adj_rec.program_application_id

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

4361: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
4362: , sysdate --p_Line_Adj_rec.creation_date
4363: , fnd_global.user_id --p_Line_Adj_rec.created_by
4364: , sysdate --p_Line_Adj_rec.last_update_date
4365: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4366: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4367: , NULL --p_Line_Adj_rec.program_application_id
4368: , NULL --p_Line_Adj_rec.program_id
4369: , NULL --p_Line_Adj_rec.program_update_date

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

4362: , sysdate --p_Line_Adj_rec.creation_date
4363: , fnd_global.user_id --p_Line_Adj_rec.created_by
4364: , sysdate --p_Line_Adj_rec.last_update_date
4365: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
4366: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
4367: , NULL --p_Line_Adj_rec.program_application_id
4368: , NULL --p_Line_Adj_rec.program_id
4369: , NULL --p_Line_Adj_rec.program_update_date
4370: , NULL --p_Line_Adj_rec.request_id

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

4505: )
4506: (SELECT *+ ORDERED USE_NL(ADJ RADJ) *
4507: adj.price_adjustment_id
4508: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4509: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4510: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4511: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4512: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4513: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

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

4507: adj.price_adjustment_id
4508: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4509: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4510: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4511: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4512: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4513: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4514: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4515: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

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

4508: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4509: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4510: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4511: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4512: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4513: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4514: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4515: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4516: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID

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

4551: )
4552: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
4553: adj.price_adjustment_id
4554: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4555: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4556: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4557: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4558: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4559: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

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

4553: adj.price_adjustment_id
4554: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4555: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4556: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4557: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4558: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4559: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4560: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4561: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

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

4554: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
4555: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
4556: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
4557: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
4558: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
4559: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4560: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4561: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4562: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID

Line 4656: ,fnd_global.user_id

4652: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4653: ,QPLAT.CONTEXT
4654: ,QPLAT.ATTRIBUTE
4655: ,sysdate
4656: ,fnd_global.user_id
4657: ,sysdate
4658: ,fnd_global.user_id
4659: ,fnd_global.login_id
4660: ,NULL

Line 4658: ,fnd_global.user_id

4654: ,QPLAT.ATTRIBUTE
4655: ,sysdate
4656: ,fnd_global.user_id
4657: ,sysdate
4658: ,fnd_global.user_id
4659: ,fnd_global.login_id
4660: ,NULL
4661: ,NULL
4662: ,NULL

Line 4659: ,fnd_global.login_id

4655: ,sysdate
4656: ,fnd_global.user_id
4657: ,sysdate
4658: ,fnd_global.user_id
4659: ,fnd_global.login_id
4660: ,NULL
4661: ,NULL
4662: ,NULL
4663: ,NULL

Line 4762: ,fnd_global.user_id

4758: l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
4759: ,QPLAT.CONTEXT
4760: ,QPLAT.ATTRIBUTE
4761: ,sysdate
4762: ,fnd_global.user_id
4763: ,sysdate
4764: ,fnd_global.user_id
4765: ,fnd_global.login_id
4766: ,NULL

Line 4764: ,fnd_global.user_id

4760: ,QPLAT.ATTRIBUTE
4761: ,sysdate
4762: ,fnd_global.user_id
4763: ,sysdate
4764: ,fnd_global.user_id
4765: ,fnd_global.login_id
4766: ,NULL
4767: ,NULL
4768: ,NULL

Line 4765: ,fnd_global.login_id

4761: ,sysdate
4762: ,fnd_global.user_id
4763: ,sysdate
4764: ,fnd_global.user_id
4765: ,fnd_global.login_id
4766: ,NULL
4767: ,NULL
4768: ,NULL
4769: ,NULL

Line 4856: ,fnd_global.user_id

4852: (SELECT ADJ.PRICE_ADJUSTMENT_ID
4853: ,QPLAT.CONTEXT
4854: ,QPLAT.ATTRIBUTE
4855: ,sysdate
4856: ,fnd_global.user_id
4857: ,sysdate
4858: ,fnd_global.user_id
4859: ,fnd_global.login_id
4860: ,NULL

Line 4858: ,fnd_global.user_id

4854: ,QPLAT.ATTRIBUTE
4855: ,sysdate
4856: ,fnd_global.user_id
4857: ,sysdate
4858: ,fnd_global.user_id
4859: ,fnd_global.login_id
4860: ,NULL
4861: ,NULL
4862: ,NULL

Line 4859: ,fnd_global.login_id

4855: ,sysdate
4856: ,fnd_global.user_id
4857: ,sysdate
4858: ,fnd_global.user_id
4859: ,fnd_global.login_id
4860: ,NULL
4861: ,NULL
4862: ,NULL
4863: ,NULL

Line 4913: ,fnd_global.user_id

4909: (SELECT ADJ.PRICE_ADJUSTMENT_ID
4910: ,QPLAT.CONTEXT
4911: ,QPLAT.ATTRIBUTE
4912: ,sysdate
4913: ,fnd_global.user_id
4914: ,sysdate
4915: ,fnd_global.user_id
4916: ,fnd_global.login_id
4917: ,NULL

Line 4915: ,fnd_global.user_id

4911: ,QPLAT.ATTRIBUTE
4912: ,sysdate
4913: ,fnd_global.user_id
4914: ,sysdate
4915: ,fnd_global.user_id
4916: ,fnd_global.login_id
4917: ,NULL
4918: ,NULL
4919: ,NULL

Line 4916: ,fnd_global.login_id

4912: ,sysdate
4913: ,fnd_global.user_id
4914: ,sysdate
4915: ,fnd_global.user_id
4916: ,fnd_global.login_id
4917: ,NULL
4918: ,NULL
4919: ,NULL
4920: ,NULL