[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 */
188: , nvl(cst.item_cost,0)+decode(sign(transaction_quantity),-1,0,
189: nvl(inv.transfer_cost,0))
190: */
191: FROM
192: MTL_MATERIAL_TRANSACTIONS inv
193: , MTL_SYSTEM_ITEMS si
194: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
195: WHERE inv.organization_id = si.organization_id
196: AND inv.inventory_item_id = si.inventory_item_id
344: END IF;
345:
346: x_return_status := 'Y';
347: -- Update the transaction table
348: UPDATE MTL_MATERIAL_TRANSACTIONS
349: SET mvt_stat_status = 'PROCESSED'
350: , movement_id = p_movement_transaction.movement_id
351: WHERE transaction_id = p_movement_transaction.mtl_transaction_id;
352: