DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on CST_QUANTITY_LAYERS

Line 743: FROM cst_quantity_layers

739: ELSE
740: BEGIN
741: SELECT NVL(item_cost,0)
742: INTO l_prior_cost
743: FROM cst_quantity_layers
744: WHERE organization_id = Item_rec.organization_id
745: AND inventory_item_id = l_item_cost_tbl(i).inventory_item_id
746: AND cost_group_id = item_rec.cost_group_id;
747: EXCEPTION

Line 828: FROM cst_quantity_layers cql,

824: SELECT 1
825: INTO l_incorrect_price_exists
826: FROM dual
827: WHERE EXISTS (SELECT cql.organization_id
828: FROM cst_quantity_layers cql,
829: org_organization_definitions ood
830: WHERE cql.organization_id = ood.organization_id
831:
832: AND cql.organization_id = Item_rec.organization_id