[Home] [Help]
2141: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': Create Accounting for same cost group transfer');
2142: END IF;
2143:
2144: -- In R12, the Inventory Offset Account field has been removed from
2145: -- the Periodic Account Assignments form, so cst_org_cost_group_accounts.
2146: -- inventory_offset_account will not be set up. Instead, we will use the
2147: -- expense account from mtl_fiscal_cat_accounts as the offset account.
2148:
2149: l_acct_rec.account := l_exp_account;
6350: -- ---------------------------------
6351: l_stmt_num := 35;
6352: select count(legal_entity_id) /* Bug No. 4586534 */
6353: into l_acct_exist
6354: from cst_org_cost_group_accounts
6355: where legal_entity_id = i_ae_txn_rec.legal_entity_id
6356: and cost_type_id = i_ae_txn_rec.cost_type_id
6357: and cost_group_id = i_ae_txn_rec.cost_group_id;
6358: if (l_acct_exist = 0) then
6398: -- --------------------------
6399: l_stmt_num := 40;
6400: select nvl(cost_variance_account,-1)
6401: into l_ae_line_rec.account
6402: from cst_org_cost_group_accounts
6403: where legal_entity_id = i_ae_txn_rec.legal_entity_id
6404: and cost_type_id = i_ae_txn_rec.cost_type_id
6405: and cost_group_id = i_ae_txn_rec.cost_group_id;
6406:
7665: Added filter on legal_entity_id and cost_Type_id */
7666:
7667: SELECT nvl(cost_variance_account,-1)
7668: INTO l_ae_line_rec.account
7669: FROM cst_org_cost_group_accounts
7670: WHERE cost_group_id=i_ae_txn_rec.cost_group_id
7671: AND legal_entity_id = i_ae_txn_rec.legal_entity_id
7672: AND cost_type_id = i_ae_txn_rec.cost_type_id;
7673: