eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TURNS dependencies on MTL_TRANSACTION_ACCOUNTS

Line 23: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_ACCOUNTS MTA

19: WHERE acct_period_id = p_acct_period_id;
20:
21: SELECT ROUND(SUM(NVL(MTA.BASE_TRANSACTION_VALUE, 0)),2) txn_val
22: INTO p_prev_onhand
23: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_ACCOUNTS MTA
24: WHERE (MTA.accounting_line_type = 1 OR MTA.accounting_line_type =
25: DECODE(MMT.transaction_action_id, 2, 99, 3, 99, 1))
26: AND SIGN(MTA.primary_quantity) =
27: DECODE(MMT.transaction_action_id, 2,

Line 455: FROM MTL_TRANSACTION_ACCOUNTS MTA, MTL_MATERIAL_TRANSACTIONS MMT,

451: SELECT p_organization_id, p_period_id, MTA.inventory_item_id,
452: SUM(NVL(MTA.base_transaction_value,0)) + NVL(MBI.onhand,0),
453: NULL, 0, NULL, SYSDATE, l_user_id, SYSDATE, l_user_id,
454: NULL,NULL,NULL,NULL,NULL
455: FROM MTL_TRANSACTION_ACCOUNTS MTA, MTL_MATERIAL_TRANSACTIONS MMT,
456: ORG_ACCT_PERIODS OAP, MTL_BIS_INV_BY_PERIOD MBI
457: WHERE (MTA.accounting_line_type = 1
458: OR MTA.accounting_line_type =
459: decode(MMT.transaction_action_id, 2, 99, 3, 99, 1))

Line 495: FROM MTL_TRANSACTION_ACCOUNTS MTA, MTL_MATERIAL_TRANSACTIONS MMT

491: SELECT /*+ leading(mmt) index(mmt mtl_material_transactions_n5) */ MTA.inventory_item_id,
492: SUM(NVL(MTA.base_transaction_value,0)) +
493: INV_TURNS.get_mbi_onhand(mta.organization_id,mta.inventory_item_id,p_last_period_id)
494: BULK COLLECT INTO l_item_id,l_item_onhand
495: FROM MTL_TRANSACTION_ACCOUNTS MTA, MTL_MATERIAL_TRANSACTIONS MMT
496: WHERE (MTA.accounting_line_type = 1
497: OR MTA.accounting_line_type =
498: decode(MMT.transaction_action_id, 2, 99, 3, 99, 1))
499: AND sign(MTA.primary_quantity) =

Line 736: FROM mtl_transaction_accounts mta,

732: Select item_id, SUM(cogs) cogs
733: from(
734: SELECT mta.inventory_item_id item_id,
735: ROUND(SUM(NVL(mta.base_transaction_value,0)),2) cogs
736: FROM mtl_transaction_accounts mta,
737: mtl_material_transactions mmt
738: WHERE mta.transaction_source_type_id = 2
739: AND mta.organization_id = p_organization_id
740: AND mmt.transaction_id = mta.transaction_id

Line 753: FROM mtl_transaction_accounts MTA,

749: GROUP BY mta.inventory_item_id
750: UNION
751: SELECT MTA.inventory_item_id item_id,
752: ROUND(SUM(NVL(MTA.base_transaction_value,0)),2) cogs
753: FROM mtl_transaction_accounts MTA,
754: mtl_material_transactions MMT1,
755: mtl_material_transactions MMT2
756: WHERE MMT2.transaction_source_type_id = 2
757: AND MTA.organization_id = p_organization_id

Line 774: FROM MTL_TRANSACTION_ACCOUNTS

770: group by item_id;
771: /* mr : mar 22nd 2000
772: SELECT ROUND(SUM(NVL(base_transaction_value,0)),2) cogs,
773: inventory_item_id item_id
774: FROM MTL_TRANSACTION_ACCOUNTS
775: WHERE transaction_source_type_id = 2
776: AND organization_id = p_organization_id
777: AND base_transaction_value > 0
778: AND TRUNC(transaction_date) between

Line 1164: FROM mtl_transaction_accounts mta,

1160: select inventory_item_id, SUM(cogs_val) cogs_val
1161: from(
1162: SELECT mta.inventory_item_id inventory_item_id,
1163: ROUND(SUM(NVL(mta.base_transaction_value,0)),2) cogs_val
1164: FROM mtl_transaction_accounts mta,
1165: mtl_material_transactions mmt
1166: WHERE mta.transaction_source_type_id = 2
1167: AND mta.organization_id = l_organization_id
1168: AND mmt.transaction_id = mta.transaction_id

Line 1182: FROM mtl_transaction_accounts MTA,

1178: GROUP BY mta.inventory_item_id
1179: UNION
1180: SELECT MTA.inventory_item_id inventory_item_id,
1181: ROUND(SUM(NVL(MTA.base_transaction_value,0)),2) cogs_val
1182: FROM mtl_transaction_accounts MTA,
1183: mtl_material_transactions MMT1,
1184: mtl_material_transactions MMT2
1185: WHERE MMT2.transaction_source_type_id = 2
1186: AND MTA.organization_id = l_organization_id

Line 1402: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_ACCOUNTS MTA

1398:
1399: CURSOR F_TXN IS
1400: SELECT /*+ index(mmt mtl_material_transactions_n5) */ MTA.inventory_item_id,
1401: ROUND(SUM(NVL(MTA.BASE_TRANSACTION_VALUE, 0)),2) txn_val
1402: FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_ACCOUNTS MTA
1403: WHERE (MTA.accounting_line_type = 1 OR MTA.accounting_line_type =
1404: DECODE(MMT.transaction_action_id, 2, 99, 3, 99, 1))
1405: AND SIGN(MTA.primary_quantity) =
1406: DECODE(MMT.transaction_action_id, 2,