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.CST_ACCRUAL_LOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 2898: FROM hr_organization_information hoi

2894: )
2895: AND mmt.transaction_date between p_from_date AND p_to_date
2896: AND EXISTS (
2897: SELECT 1
2898: FROM hr_organization_information hoi
2899: WHERE --{BUG#8398114
2900: -- hoi.organization_id = mmt.organization_id
2901: (hoi.organization_id = mmt.organization_id OR
2902: hoi.organization_id = mmt.transfer_organization_id)

Line 3034: FROM hr_organization_information hoi

3030: AND mp.process_enabled_flag = 'Y' /* Bug 13728770 */
3031: AND mmt.transaction_date between p_from_date AND p_to_date
3032: AND EXISTS (
3033: SELECT 1
3034: FROM hr_organization_information hoi
3035: WHERE hoi.organization_id = mmt.organization_id
3036: AND hoi.org_information_context = 'Accounting Information'
3037: AND hoi.org_information3 = to_char(p_operating_unit) --bug 10648494
3038: )

Line 3117: FROM hr_organization_information hoi

3113: AND mp.process_enabled_flag = 'Y' /* Bug 13728770 */
3114: AND mmt.transaction_date between p_from_date AND p_to_date
3115: AND EXISTS (
3116: SELECT 1
3117: FROM hr_organization_information hoi
3118: WHERE hoi.organization_id = mmt.organization_id
3119: AND hoi.org_information_context = 'Accounting Information'
3120: AND hoi.org_information3 = to_char(p_operating_unit) --bug 10648494
3121: )

Line 3165: hr_organization_information hoi1,

3161: SET cmr.vendor_id = (
3162: SELECT mip.vendor_id
3163: FROM mtl_material_transactions mmt,
3164: mtl_intercompany_parameters mip,
3165: hr_organization_information hoi1,
3166: hr_organization_information hoi2
3167: WHERE mmt.transaction_id = cmr.inventory_transaction_id
3168: AND hoi1.org_information_context = 'Accounting Information'
3169: AND hoi1.organization_id = decode(mmt.transaction_action_id,

Line 3166: hr_organization_information hoi2

3162: SELECT mip.vendor_id
3163: FROM mtl_material_transactions mmt,
3164: mtl_intercompany_parameters mip,
3165: hr_organization_information hoi1,
3166: hr_organization_information hoi2
3167: WHERE mmt.transaction_id = cmr.inventory_transaction_id
3168: AND hoi1.org_information_context = 'Accounting Information'
3169: AND hoi1.organization_id = decode(mmt.transaction_action_id,
3170: 12,mmt.transfer_organization_id,