APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on CST_STANDARD_COSTS

Line 423: cst_standard_costs csc

419: max(standard_cost_revision_date) standard_cost_revision_date,
420: p.primary_cost_method cost_method,
421: NULL cost_group_id -- RS: Bug fix 5219487 p.default_cost_group_id cost_group_id
422: FROM mtl_parameters p,
423: cst_standard_costs csc
424: -- not using <= below because txns are
425: -- collected from GSD onward. hence if there is
426: -- any cost update as of GSD additional 24 txns
427: -- will come in separately.

Line 436: cst_standard_costs csc

432: csc.inventory_item_id,
433: p.primary_cost_method,
434: p.default_cost_group_id
435: ) csc2,
436: cst_standard_costs csc
437: WHERE csc.organization_id = csc2.organization_id
438: AND csc.inventory_item_id = csc2.inventory_item_id
439: AND csc.standard_cost_revision_date = csc2.standard_cost_revision_date
440: and fact.organization_id = csc2.organization_id

Line 506: (select 1 from cst_standard_costs csc

502: AND new_cost is not null
503: AND ((stg.onhand_value_b is null and nvl(stg.onhand_qty,0) <> 0 )
504: OR (stg.intransit_value_b is null and nvl(stg.intransit_qty,0) <> 0 ))
505: and exists
506: (select 1 from cst_standard_costs csc
507: where stg.inventory_item_id = csc.inventory_item_id
508: AND stg.organization_id = csc.organization_id
509: and standard_cost_revision_date >= g_global_start_date)
510: GROUP BY mmt.organization_id,