APPS.ENI_DBI_UCO_LOAD_PKG dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 213: -- Get the cost history for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.

209:
210: commit; -- commit the standard costing data into staging table.
211:
212:
213: -- Get the cost history for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.
214: if (l_exists_ac_orgs = 1) then
215:
216: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting initial cost collection into stage table for them');
217:

Line 264: mtl_cst_actual_cost_details mcacd,

260: and mmt.cost_group_id = cql.cost_group_id
261: group by mmt.inventory_item_id, mmt.organization_id,
262: cql.layer_id,
263: trunc (mmt.transaction_date)) x,
264: mtl_cst_actual_cost_details mcacd,
265: hr_organization_information hoi,
266: gl_sets_of_books gsob
267: where mcacd.transaction_id = x.transaction_id
268: and mcacd.organization_id = x.organization_id

Line 785: -- Get the cost changes for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.

781: end if;
782:
783: commit; -- commit the standard costing data into the staging.
784:
785: -- Get the cost changes for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.
786: if (l_exists_ac_orgs = 1) then
787:
788: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting incremental cost collection for them');
789:

Line 854: mtl_cst_actual_cost_details mcacd,

850: and mmt.cost_group_id = cql.cost_group_id
851: group by mmt.inventory_item_id, mmt.organization_id,
852: cql.layer_id,
853: trunc (mmt.transaction_date)) x,
854: mtl_cst_actual_cost_details mcacd,
855: hr_organization_information hoi,
856: gl_sets_of_books gsob
857: where mcacd.transaction_id = x.transaction_id
858: and mcacd.organization_id = x.organization_id