DBA Data[Home] [Help]

APPS.CSTPLMWI dependencies on CST_QUANTITY_LAYERS

Line 665: FROM cst_quantity_layers

661: if (l_exp_item_flag <> 1) then
662: l_stmt_num := 45;
663: SELECT cost_group_id
664: INTO l_cost_group_id
665: FROM cst_quantity_layers
666: WHERE layer_id = i_layer_id;
667:
668: l_stmt_num := 48;
669: SELECT NVL(MIN(CQL.layer_id),-1)

Line 671: FROM cst_quantity_layers CQL

667:
668: l_stmt_num := 48;
669: SELECT NVL(MIN(CQL.layer_id),-1)
670: INTO l_item_layer_id
671: FROM cst_quantity_layers CQL
672: WHERE CQL.inventory_item_id = i_inv_item_id
673: AND CQL.organization_id = i_org_id
674: AND CQL.cost_group_id = l_cost_group_id;
675: