DBA Data[Home] [Help]

APPS.INV_MGD_MVT_INV_MDTR dependencies on CST_ITEM_COSTS_FOR_GL_VIEW

Line 172: --Bugfix 12844667: Removing CST_ITEM_COSTS_FOR_GL_VIEW since this table doesn't have

168: )
169: IS
170: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_INV_Details';
171:
172: --Bugfix 12844667: Removing CST_ITEM_COSTS_FOR_GL_VIEW since this table doesn't have
173: --data for process orgs.
174: CURSOR inv_details IS
175: SELECT
176: inv.freight_code

Line 194: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

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
197: --AND inv.organization_id = cst.organization_id(+)
198: --AND inv.inventory_item_id = cst.inventory_item_id(+)

Line 206: CST_ITEM_COSTS_FOR_GL_VIEW

202: CURSOR c_item_cost IS
203: SELECT
204: item_cost
205: FROM
206: CST_ITEM_COSTS_FOR_GL_VIEW
207: WHERE organization_id = x_movement_transaction.from_organization_id
208: AND inventory_item_id = x_movement_transaction.inventory_item_id;
209:
210: BEGIN