DBA Data[Home] [Help]

APPS.INV_TURNS dependencies on CST_QUANTITY_LAYERS

Line 1114: FROM cst_quantity_layers cql,

1110:
1111: CURSOR OPEN_ONHAND IS
1112: SELECT cql.inventory_item_id,
1113: ROUND(SUM(NVL((cql.layer_quantity * cql.item_cost),0)),2) onhand
1114: FROM cst_quantity_layers cql,
1115: mtl_parameters mp
1116: WHERE cql.organization_id = l_organization_id
1117: AND cql.organization_id = mp.organization_id
1118: AND mp.primary_cost_method IN (2,5,6)