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 151: FROM hr_organization_information LEI

147: Bug No - 4336479
148: begin
149: SELECT to_number(LEI.org_information1)
150: INTO l_sob_id
151: FROM hr_organization_information LEI
152: , hr_organization_information OUI
153: , hr_organization_units OU
154: , hr_organization_units LE
155: WHERE OU.organization_id = l_selling_org_id

Line 152: , hr_organization_information OUI

148: begin
149: SELECT to_number(LEI.org_information1)
150: INTO l_sob_id
151: FROM hr_organization_information LEI
152: , hr_organization_information OUI
153: , hr_organization_units OU
154: , hr_organization_units LE
155: WHERE OU.organization_id = l_selling_org_id
156: AND LEI.org_information_context = 'Legal Entity Accounting'

Line 892: FROM hr_organization_information hoi,

888: l_ship_from_org_id,
889: l_organization_id,
890: l_item_id,
891: l_transaction_date
892: FROM hr_organization_information hoi,
893: oe_order_lines_all oola,
894: mtl_material_transactions mmt
895: WHERE mmt.transaction_id = p_transaction_id
896: AND mmt.trx_source_line_id = oola.line_id

Line 1731: FROM hr_organization_information

1727: l_progress := 150;
1728: IF (l_mtl_trx_tbl(i).cost_group_id IS NULL) THEN
1729: SELECT to_number(org_information3)
1730: INTO l_rec_start_org_id
1731: FROM hr_organization_information
1732: WHERE organization_id = l_mtl_trx_tbl(i).organization_id
1733: AND org_information_context = 'Accounting Information';
1734:
1735: -- For the first node, check if there's project tied to the locator