DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on CST_COST_GROUP_ACCOUNTS

Line 687: from cst_cost_groups ccg, cst_cost_group_accounts ccga

683: , description
684: FROM cst_cost_groups
685: WHERE cost_group LIKE (p_cost_group); */
686: select ccg.cost_group ,ccga.cost_group_id, ccg.description
687: from cst_cost_groups ccg, cst_cost_group_accounts ccga
688: where ccg.cost_group_id = ccga.cost_group_id
689: and ccga.organization_id = nvl(p_organization_id, ccga.organization_id)
690: --WHERE organization_id = p_organization_id
691: and ccg.cost_group LIKE (p_cost_group);

Line 776: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga

772: OPEN x_cost_group_lov FOR
773: SELECT ccg.cost_group
774: , ccg.cost_group_id
775: , ccg.description
776: FROM cst_cost_groups ccg, cst_cost_group_accounts ccga
777: WHERE ccg.cost_group LIKE (p_to_cost_group)
778: AND ccg.cost_group_id = ccga.cost_group_id
779: AND ccga.cost_group_id <> p_from_cost_group_id
780: AND ccg.cost_group_type <> 1 --PJM-WMS Integration