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_LOGICAL_TRANSACTIONS_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 135: FROM hr_organization_information LEI

131: Bug No - 4336479
132: begin
133: SELECT to_number(LEI.org_information1)
134: INTO l_sob_id
135: FROM hr_organization_information LEI
136: , hr_organization_information OUI
137: , hr_organization_units OU
138: , hr_organization_units LE
139: WHERE OU.organization_id = l_selling_org_id

Line 136: , hr_organization_information OUI

132: begin
133: SELECT to_number(LEI.org_information1)
134: INTO l_sob_id
135: FROM hr_organization_information LEI
136: , hr_organization_information OUI
137: , hr_organization_units OU
138: , hr_organization_units LE
139: WHERE OU.organization_id = l_selling_org_id
140: AND LEI.org_information_context = 'Legal Entity Accounting'

Line 876: FROM hr_organization_information hoi,

872: l_ship_from_org_id,
873: l_organization_id,
874: l_item_id,
875: l_transaction_date
876: FROM hr_organization_information hoi,
877: oe_order_lines_all oola,
878: mtl_material_transactions mmt
879: WHERE mmt.transaction_id = p_transaction_id
880: AND mmt.trx_source_line_id = oola.line_id

Line 1714: FROM hr_organization_information

1710: l_progress := 150;
1711: IF (l_mtl_trx_tbl(i).cost_group_id IS NULL) THEN
1712: SELECT to_number(org_information3)
1713: INTO l_rec_start_org_id
1714: FROM hr_organization_information
1715: WHERE organization_id = l_mtl_trx_tbl(i).organization_id
1716: AND org_information_context = 'Accounting Information';
1717:
1718: -- For the first node, check if there's project tied to the locator