DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on CST_COST_GROUP_ACCOUNTS

Line 709: from cst_cost_groups ccg, cst_cost_group_accounts ccga

705: , description
706: FROM cst_cost_groups
707: WHERE cost_group LIKE (p_cost_group); */
708: select ccg.cost_group ,ccga.cost_group_id, ccg.description
709: from cst_cost_groups ccg, cst_cost_group_accounts ccga
710: where ccg.cost_group_id = ccga.cost_group_id
711: and ccga.organization_id = nvl(p_organization_id, ccga.organization_id)
712: --WHERE organization_id = p_organization_id
713: and ccg.cost_group LIKE (p_cost_group);

Line 798: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga

794: OPEN x_cost_group_lov FOR
795: SELECT ccg.cost_group
796: , ccg.cost_group_id
797: , ccg.description
798: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga
799: WHERE ccg.cost_group LIKE (p_to_cost_group)
800: AND ccg.cost_group_id = ccga.cost_group_id
801: AND ccga.cost_group_id <> p_from_cost_group_id
802: AND ccg.cost_group_type <> 1 --PJM-WMS Integration