[Home] [Help]
464: SELECT CCG.cost_group_id
465: FROM cst_cost_groups CCG,
466: (SELECT organization_id,
467: cost_group_id
468: FROM cst_cost_group_accounts
469: UNION
470: /* This is required for cases where default
471: cost group id is 1 and it doesn't exist
472: in cst_cost_group_accounts */
468: FROM cst_cost_group_accounts
469: UNION
470: /* This is required for cases where default
471: cost group id is 1 and it doesn't exist
472: in cst_cost_group_accounts */
473: SELECT organization_id,
474: default_cost_group_id cost_group_id
475: FROM mtl_parameters
476: ) CCGA
509: CCG.cost_group_id
510: FROM cst_cost_groups CCG,
511: (SELECT organization_id,
512: cost_group_id
513: FROM cst_cost_group_accounts
514: UNION
515: /* This is required for cases where default
516: cost group id is 1 and it doesn't exist
517: in cst_cost_group_accounts */
513: FROM cst_cost_group_accounts
514: UNION
515: /* This is required for cases where default
516: cost group id is 1 and it doesn't exist
517: in cst_cost_group_accounts */
518: SELECT organization_id,
519: default_cost_group_id cost_group_id
520: FROM mtl_parameters
521: ) CCGA,