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

Line 2612: hr_organization_information hoi,

2608: into
2609: l_ship_chart_of_accounts_id
2610: from
2611: gl_sets_of_books gsob,
2612: hr_organization_information hoi,
2613: hr_organization_information hoi1
2614: where
2615: hoi1.organization_id = p_ship_organization_id
2616: and hoi1.org_information_context = 'Operating Unit Information'

Line 2613: hr_organization_information hoi1

2609: l_ship_chart_of_accounts_id
2610: from
2611: gl_sets_of_books gsob,
2612: hr_organization_information hoi,
2613: hr_organization_information hoi1
2614: where
2615: hoi1.organization_id = p_ship_organization_id
2616: and hoi1.org_information_context = 'Operating Unit Information'
2617: and hoi.organization_id = to_number(hoi1.org_information2)

Line 2657: hr_organization_information hoi,

2653: into
2654: l_chart_of_accounts_id
2655: from
2656: gl_sets_of_books gsob,
2657: hr_organization_information hoi,
2658: hr_organization_information hoi1
2659: where hoi1.organization_id = p_sell_organization_id
2660: and hoi1.org_information_context = 'Operating Unit Information'
2661: and hoi.organization_id = to_number(hoi1.org_information2)

Line 2658: hr_organization_information hoi1

2654: l_chart_of_accounts_id
2655: from
2656: gl_sets_of_books gsob,
2657: hr_organization_information hoi,
2658: hr_organization_information hoi1
2659: where hoi1.organization_id = p_sell_organization_id
2660: and hoi1.org_information_context = 'Operating Unit Information'
2661: and hoi.organization_id = to_number(hoi1.org_information2)
2662: and hoi.org_information_context = 'Legal Entity Accounting'

Line 3073: FROM HR_ORGANIZATION_INFORMATION HOI

3069:
3070: BEGIN
3071: SELECT org_information3
3072: INTO l_ship_from_ou
3073: FROM HR_ORGANIZATION_INFORMATION HOI
3074: WHERE HOI.ORGANIZATION_ID= l_ship_from_org_id
3075: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information';
3076: EXCEPTION
3077: WHEN no_data_found THEN

Line 3414: FROM HR_ORGANIZATION_INFORMATION LEI, HR_ORGANIZATION_UNITS OU,

3410: BEGIN
3411: l_progress := 1;
3412: SELECT to_number(LEI.org_information1)
3413: into l_set_of_book_id
3414: FROM HR_ORGANIZATION_INFORMATION LEI, HR_ORGANIZATION_UNITS OU,
3415: HR_ORGANIZATION_INFORMATION OUI
3416: WHERE OU.organization_id = p_org_id
3417: AND LEI.org_information_context = 'Legal Entity Accounting'
3418: AND to_char(LEI.organization_id) = OUI.org_information2

Line 3415: HR_ORGANIZATION_INFORMATION OUI

3411: l_progress := 1;
3412: SELECT to_number(LEI.org_information1)
3413: into l_set_of_book_id
3414: FROM HR_ORGANIZATION_INFORMATION LEI, HR_ORGANIZATION_UNITS OU,
3415: HR_ORGANIZATION_INFORMATION OUI
3416: WHERE OU.organization_id = p_org_id
3417: AND LEI.org_information_context = 'Legal Entity Accounting'
3418: AND to_char(LEI.organization_id) = OUI.org_information2
3419: AND OUI.org_information_context = 'Operating Unit Information'

Line 4648: FROM HR_ORGANIZATION_INFORMATION HOI

4644: print_debug('Check if the from OU is valid ', 'GET_TRANSFER_PRICE');
4645:
4646: select count(organization_id)
4647: into l_exists
4648: FROM HR_ORGANIZATION_INFORMATION HOI
4649: WHERE HOI.ORG_INFORMATION3 = to_char(p_from_org_id)
4650: AND HOI.ORGANIZATION_ID= l_organization_id
4651: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information';
4652: