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_MATERIAL_TRANSACTIONS

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 491: SELECT /+ leading(mmt) index(mmt mtl_material_transactions_n5) / MTA.inventory_item_id,

487:
488: -- performance bug 4951748, sql 14818635
489: -- index hint is added
490:
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

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 737: mtl_material_transactions mmt

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
741: AND mmt.transaction_action_id = 1 -- Issues from stores

Line 754: mtl_material_transactions MMT1,

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
758: AND MMT1.transaction_id = MTA.transaction_id

Line 755: mtl_material_transactions MMT2

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
758: AND MMT1.transaction_id = MTA.transaction_id
759: AND MMT1.PARENT_TRANSACTION_ID = MMT2.transaction_id

Line 1165: mtl_material_transactions mmt

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
1169: AND mmt.transaction_action_id = 1 -- Issues from stores

Line 1183: mtl_material_transactions MMT1,

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
1187: AND MMT1.transaction_id = MTA.transaction_id

Line 1184: mtl_material_transactions MMT2

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
1187: AND MMT1.transaction_id = MTA.transaction_id
1188: AND MMT1.PARENT_TRANSACTION_ID = MMT2.transaction_id

Line 1400: SELECT /+ index(mmt mtl_material_transactions_n5) / MTA.inventory_item_id,

1396: -- performance bug 4951748, sql 14819227
1397: -- index hint is added
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))

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,