DBA Data[Home] [Help]

APPS.CSTPPLLC dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 49: FROM cst_cost_group_assignments

45: AND transaction_date BETWEEN trunc(c_start_date)
46: AND (trunc(c_end_date) + 0.99999)
47: AND EXISTS(
48: SELECT 'exists'
49: FROM cst_cost_group_assignments
50: WHERE cost_group_id = c_cost_group_id
51: AND organization_id = mmt.organization_id);
52:
53: comp_rec C_assm_comp%ROWTYPE;

Line 375: FROM cst_cost_group_assignments

371: AND mmt1.transaction_date BETWEEN trunc(c_start_date)
372: AND (trunc(c_end_date) + 0.99999)
373: AND (
374: SELECT count('exists')
375: FROM cst_cost_group_assignments
376: WHERE cost_group_id = c_cost_group_id
377: AND organization_id = mmt1.organization_id
378: and rownum < 2 ) > 0
379: AND mmt2.inventory_item_id = cpet.component_item_id