APPS.INV_MGD_MVT_INV_MDTR dependencies on HR_ORGANIZATION_INFORMATION

Line 72: --Fix performance bug 4912552, use hr_organization_information to replace

68: CLOSE inv_crsr;
69: END IF;
70:
71:
72: --Fix performance bug 4912552, use hr_organization_information to replace
73: --org_organization_definitions according to proposal from INV
74: --karthik.gnanamurthy, because inventory organization is already existing
75: --in mtl_material_transactions, so it's not required to validate the organization
76: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 93: , hr_organization_information hoi

89: , inv.subinventory_code
90: , inv.transfer_subinventory
91: FROM
92: MTL_MATERIAL_TRANSACTIONS inv
93: , hr_organization_information hoi
94: WHERE inv.organization_id = hoi.organization_id
95: AND hoi.org_information_context = 'Accounting Information'
96: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
97: AND inv.transaction_type_id IN (21,3,12,2)

Line 116: , hr_organization_information hoi

112: , inv.subinventory_code
113: , inv.transfer_subinventory
114: FROM
115: MTL_MATERIAL_TRANSACTIONS inv
116: , hr_organization_information hoi
117: WHERE inv.organization_id = hoi.organization_id
118: AND hoi.org_information_context = 'Accounting Information'
119: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
120: AND inv.transaction_id = p_movement_transaction.mtl_transaction_id