APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_TRANSACTION_ACCOUNTS

Line 528: ( SELECT 1 FROM MTL_TRANSACTION_ACCOUNTS

524: mmt.program_application_id = p_prg_appl_id,
525: mmt.program_id = p_prg_id,
526: mmt.program_update_date = sysdate
527: WHERE NOT EXISTS
528: ( SELECT 1 FROM MTL_TRANSACTION_ACCOUNTS
529: WHERE TRANSACTION_ID = mmt.TRANSACTION_ID
530: AND cost_element_id = 2
531: AND accounting_line_type = 3
532: )

Line 6913: FROM mtl_transaction_accounts mta

6909: END IF;
6910:
6911: SELECT NVL(MAX(mta.reference_account), -999999)
6912: INTO O_dr_code_combination_id
6913: FROM mtl_transaction_accounts mta
6914: WHERE
6915: mta.transaction_id = l_mta_transaction_id AND
6916: mta.organization_id = l_mta_organization_id AND
6917: mta.inventory_item_id = l_inventory_item_id AND

Line 6936: FROM mtl_transaction_accounts mta

6932: If O_dr_code_combination_id <> -999999 then
6933:
6934: SELECT MAX(INV_SUB_LEDGER_ID)
6935: INTO O_inv_dr_sub_ledger_id
6936: FROM mtl_transaction_accounts mta
6937: WHERE
6938: mta.reference_account = O_dr_code_combination_id AND
6939: mta.transaction_id = l_mta_transaction_id AND
6940: mta.organization_id = l_mta_organization_id AND

Line 6981: from mtl_transaction_accounts mta

6977: into l_cc_rate,
6978: l_cc_type,
6979: l_cc_date,
6980: l_cc_foreign_currency
6981: from mtl_transaction_accounts mta
6982: where mta.transaction_id = l_mta_transaction_id
6983: and mta.organization_id = l_mta_organization_id
6984: and mta.accounting_line_type <> 15 /*Added for Encumbrance project */
6985: and mta.transaction_value is not null

Line 7049: FROM mtl_transaction_accounts mta

7045: IF (l_citw_flag = 1) THEN /* MAIN IF */
7046: SELECT
7047: NVL((MAX(mta.reference_account)),-999999)
7048: INTO O_cr_code_combination_id
7049: FROM mtl_transaction_accounts mta
7050: WHERE mta.transaction_id = p_transaction_id
7051: AND mta.organization_id = l_organization_id
7052: AND mta.inventory_item_id = l_inventory_item_id
7053: AND NVL(mta.cost_element_id,-99)= NVL(p_cost_element_id,-99)

Line 7064: from mtl_transaction_accounts mta

7060: /* changes to get the Credit INV sub ledger ID for the credit side from MTA */
7061:
7062: Select MAX(INV_SUB_LEDGER_ID)
7063: into O_inv_cr_sub_ledger_id
7064: from mtl_transaction_accounts mta
7065: where mta.reference_account = O_cr_code_combination_id
7066: AND mta.transaction_id = p_transaction_id
7067: AND mta.organization_id = l_organization_id
7068: AND mta.inventory_item_id = l_inventory_item_id

Line 7236: FROM mtl_transaction_accounts mta

7232: /* Non blue print or non project transfer txns
7233: changed the join condition on the cost element ID to get the correct account */
7234: SELECT NVL(MAX(mta.reference_account), -999999)
7235: INTO O_cr_code_combination_id
7236: FROM mtl_transaction_accounts mta
7237: WHERE
7238: mta.transaction_id =l_mta_transaction_id AND
7239: mta.organization_id =l_mta_organization_id AND
7240: mta.inventory_item_id =l_inventory_item_id AND

Line 7251: FROM mtl_transaction_accounts mta

7247: /* Changes to get the INV sub ledger ID for the credit account from MTA */
7248:
7249: SELECT MAX(INV_SUB_LEDGER_ID)
7250: INTO O_inv_cr_sub_ledger_id
7251: FROM mtl_transaction_accounts mta
7252: WHERE
7253: mta.reference_account = O_cr_code_combination_id AND
7254: mta.transaction_id =l_mta_transaction_id AND
7255: mta.organization_id =l_mta_organization_id AND