DBA Data[Home] [Help]

APPS.CSTPLMWI dependencies on CST_QUANTITY_LAYERS

Line 666: FROM cst_quantity_layers

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

Line 672: FROM cst_quantity_layers CQL

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