APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_TRANSACTION_ACCOUNTS

Line 6774: FROM mtl_transaction_accounts mta

6770: END IF;
6771:
6772: SELECT NVL(MAX(mta.reference_account), -999999)
6773: INTO O_dr_code_combination_id
6774: FROM mtl_transaction_accounts mta
6775: WHERE
6776: mta.transaction_id = l_mta_transaction_id AND
6777: mta.organization_id = l_mta_organization_id AND
6778: mta.inventory_item_id = l_inventory_item_id AND

Line 6797: FROM mtl_transaction_accounts mta

6793: If O_dr_code_combination_id <> -999999 then
6794:
6795: SELECT MAX(INV_SUB_LEDGER_ID)
6796: INTO O_inv_dr_sub_ledger_id
6797: FROM mtl_transaction_accounts mta
6798: WHERE
6799: mta.reference_account = O_dr_code_combination_id AND
6800: mta.transaction_id = l_mta_transaction_id AND
6801: mta.organization_id = l_mta_organization_id AND

Line 6829: FROM mtl_transaction_accounts mta

6825: IF (l_citw_flag = 1) THEN /* MAIN IF */
6826: SELECT
6827: NVL((MAX(mta.reference_account)),-999999)
6828: INTO O_cr_code_combination_id
6829: FROM mtl_transaction_accounts mta
6830: WHERE mta.transaction_id = p_transaction_id
6831: AND mta.organization_id = l_organization_id
6832: AND mta.inventory_item_id = l_inventory_item_id
6833: AND NVL(mta.cost_element_id,-99)= NVL(p_cost_element_id,-99)

Line 6844: from mtl_transaction_accounts mta

6840: /* changes to get the Credit INV sub ledger ID for the credit side from MTA */
6841:
6842: Select MAX(INV_SUB_LEDGER_ID)
6843: into O_inv_cr_sub_ledger_id
6844: from mtl_transaction_accounts mta
6845: where mta.reference_account = O_cr_code_combination_id
6846: AND mta.transaction_id = p_transaction_id
6847: AND mta.organization_id = l_organization_id
6848: AND mta.inventory_item_id = l_inventory_item_id

Line 7016: FROM mtl_transaction_accounts mta

7012: /* Non blue print or non project transfer txns
7013: changed the join condition on the cost element ID to get the correct account */
7014: SELECT NVL(MAX(mta.reference_account), -999999)
7015: INTO O_cr_code_combination_id
7016: FROM mtl_transaction_accounts mta
7017: WHERE
7018: mta.transaction_id =l_mta_transaction_id AND
7019: mta.organization_id =l_mta_organization_id AND
7020: mta.inventory_item_id =l_inventory_item_id AND

Line 7030: FROM mtl_transaction_accounts mta

7026: /* Changes to get the INV sub ledger ID for the credit account from MTA */
7027:
7028: SELECT MAX(INV_SUB_LEDGER_ID)
7029: INTO O_inv_cr_sub_ledger_id
7030: FROM mtl_transaction_accounts mta
7031: WHERE
7032: mta.reference_account = O_cr_code_combination_id AND
7033: mta.transaction_id =l_mta_transaction_id AND
7034: mta.organization_id =l_mta_organization_id AND