[Home] [Help]
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
77:
78: IF NVL(p_movement_transaction.creation_method,'A') = 'A' THEN
79:
88: , inv.transaction_quantity
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 */
111: , inv.transaction_quantity
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 */
184: , si.description
185: , nvl(cst.item_cost,0)+decode(sign(transaction_quantity),-1,0,
186: nvl(inv.transfer_cost,0))
187: FROM
188: MTL_MATERIAL_TRANSACTIONS inv
189: , MTL_SYSTEM_ITEMS si
190: , CST_ITEM_COSTS_FOR_GL_VIEW cst
191: WHERE inv.organization_id = si.organization_id
192: AND inv.inventory_item_id = si.inventory_item_id
315: END IF;
316:
317: x_return_status := 'Y';
318: -- Update the transaction table
319: UPDATE MTL_MATERIAL_TRANSACTIONS
320: SET mvt_stat_status = 'PROCESSED'
321: , movement_id = p_movement_transaction.movement_id
322: WHERE transaction_id = p_movement_transaction.mtl_transaction_id;
323: