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.CST_REVENUECOGSMATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 658: FROM mtl_material_transactions mmt,

654: mmt.inventory_item_id,
655: mmt.transaction_date,
656: mmt.cost_group_id,
657: (-1*mmt.primary_quantity) quantity
658: FROM mtl_material_transactions mmt,
659: mtl_parameters mp,
660: mtl_secondary_inventories msi,
661: mtl_system_items_b item
662: ,cst_acct_info_v caiv --BUG#7463298

Line 695: FROM mtl_material_transactions mmt,

691: mmt.inventory_item_id,
692: mmt.transaction_date,
693: mmt.cost_group_id,
694: (-1*mmt.primary_quantity) quantity
695: FROM mtl_material_transactions mmt,
696: mtl_parameters mp,
697: mtl_secondary_inventories msi,
698: mtl_system_items_b item
699: ,cst_acct_info_v caiv --BUG#7463298

Line 877: FROM mtl_material_transactions mmt,

873: (-1*mmt.primary_quantity) event_quantity,
874: cce.parent_event_id prior_event_id,
875: cce.cogs_percentage cogs_percentage,
876: sum(cce.event_quantity) prior_event_quantity
877: FROM mtl_material_transactions mmt,
878: oe_order_lines_all ool,
879: cst_revenue_cogs_match_lines crcml,
880: cst_cogs_events cce,
881: mtl_system_items_b item

Line 902: FROM mtl_material_transactions mmt_rma

898: -- Physical RMA should not have a logical RMA as child transaction
899: -- otherwise this drop ship return COGS is carried by the logical RMA
900: AND NOT EXISTS
901: (SELECT NULL
902: FROM mtl_material_transactions mmt_rma
903: WHERE mmt_rma.transaction_source_type_id = 12
904: AND mmt_rma.transaction_action_id = 26
905: AND mmt_rma.parent_transaction_id = mmt.transaction_id)
906: )

Line 945: FROM mtl_material_transactions mmt,

941: (-1*mmt.primary_quantity) event_quantity,
942: cce.parent_event_id prior_event_id,
943: cce.cogs_percentage cogs_percentage,
944: sum(cce.event_quantity) prior_event_quantity
945: FROM mtl_material_transactions mmt,
946: oe_order_lines_all ool,
947: cst_revenue_cogs_match_lines crcml,
948: cst_cogs_events cce,
949: mtl_system_items_b item

Line 970: FROM mtl_material_transactions mmt_rma

966: -- Physical RMA should not have a logical RMA as child transaction
967: -- otherwise this drop ship return COGS is carried by the logical RMA
968: AND NOT EXISTS
969: (SELECT NULL
970: FROM mtl_material_transactions mmt_rma
971: WHERE mmt_rma.transaction_source_type_id = 12
972: AND mmt_rma.transaction_action_id = 26
973: AND mmt_rma.parent_transaction_id = mmt.transaction_id)
974: )

Line 1201: UPDATE mtl_material_transactions

1197: -- to the revenue / COGS matching data model.
1198: l_stmt_num := 40;
1199: debug(l_stmt_num);
1200: FORALL i IN l_cogs_om_line_id_tbl.FIRST..l_cogs_om_line_id_tbl.LAST
1201: UPDATE mtl_material_transactions
1202: SET cogs_recognition_percent = l_prior_percent_tbl(i),
1203: last_update_date = sysdate,
1204: last_updated_by = p_user_id,
1205: last_update_login = p_login_id,

Line 1261: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,

1257: opm_org_flag,
1258: acct_period_id
1259: )
1260: SELECT cst_cogs_events_s.nextval,
1261: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1262: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1263: NULL),
1264: cce.cogs_om_line_id,
1265: l_rma_om_line_id_tbl(i),

Line 1262: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,

1258: acct_period_id
1259: )
1260: SELECT cst_cogs_events_s.nextval,
1261: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1262: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1263: NULL),
1264: cce.cogs_om_line_id,
1265: l_rma_om_line_id_tbl(i),
1266: cce.event_date,

Line 1598: ,mtl_material_transactions mmt

1594: gl_period_statuses gps,
1595: cst_lists_temp clt,
1596: mtl_system_items msi
1597: --{BUG#6809034
1598: ,mtl_material_transactions mmt
1599: --}
1600: WHERE crrl.ledger_id = p_sob_id
1601: AND crrl.acct_period_num = p_process_acct_period_num
1602: AND crrl.potentially_unmatched_flag = 'Y' -- Indexed column should substantially reduce the rows

Line 2060: mtl_material_transactions_s.nextval,

2056: --nvl(l_alternate_event_date+EndDateNum+l_date_offset_tbl(i),l_event_date_tbl(i)),
2057: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),
2058: --l_event_date_tbl(i),
2059: --
2060: mtl_material_transactions_s.nextval,
2061: l_new_percentage_tbl(i),
2062: l_prior_percentage_tbl(i),
2063: l_prior_event_id_tbl(i),
2064: COGS_RECOGNITION_EVENT,

Line 2204: mtl_material_transactions_s.nextval,

2200: opm_org_flag,
2201: acct_period_id
2202: )
2203: SELECT cst_cogs_events_s.nextval,
2204: mtl_material_transactions_s.nextval,
2205: cogs_om_line_id,
2206: event_date,
2207: l_prior_percentage_tbl(i), -- could also use cce.prior_cogs_percentage
2208: l_new_percentage_tbl(i),

Line 2819: UPDATE mtl_material_transactions

2815: l_stmt_num := 70;
2816: debug(l_stmt_num);
2817: -- Mark the cogs percentage column in the MMT transaction, thus indicating that it has been added
2818: -- to the revenue / COGS matching data model.
2819: UPDATE mtl_material_transactions
2820: SET cogs_recognition_percent = 0,
2821: last_update_date = sysdate,
2822: last_updated_by = p_user_id,
2823: last_update_login = p_login_id,

Line 3113: UPDATE mtl_material_transactions

3109: -- Mark the cogs percentage column in the MMT transaction, thus indicating that it has been added
3110: -- to the revenue / COGS matching data model.
3111: l_stmt_num := 40;
3112: debug(l_stmt_num);
3113: UPDATE mtl_material_transactions
3114: SET cogs_recognition_percent = l_cogs_percentage,
3115: last_update_date = sysdate,
3116: last_updated_by = p_user_id,
3117: last_update_login = p_login_id,

Line 3164: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,

3160: opm_org_flag,
3161: acct_period_id
3162: )
3163: SELECT cst_cogs_events_s.nextval,
3164: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3165: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3166: NULL),
3167: cce.cogs_om_line_id,
3168: p_rma_om_line_id,

Line 3165: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,

3161: acct_period_id
3162: )
3163: SELECT cst_cogs_events_s.nextval,
3164: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3165: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3166: NULL),
3167: cce.cogs_om_line_id,
3168: p_rma_om_line_id,
3169: cce.event_date,

Line 4223: mtl_material_transactions mmt -- joining here to use the index on costed_flag

4219: FROM cst_cogs_events cce,
4220: cst_revenue_cogs_match_lines crcml,
4221: mtl_parameters mp,
4222: gl_sets_of_books sob,
4223: mtl_material_transactions mmt -- joining here to use the index on costed_flag
4224: WHERE
4225: cce.mmt_transaction_id = mmt.transaction_id
4226: AND mmt.costed_flag = 'N'
4227: AND mmt.transaction_action_id = 36

Line 4501: UPDATE mtl_material_transactions

4497:
4498: l_stmt_num := 50;
4499: -- Update the costed flag in MMT
4500: FORALL i IN l_event_id_tbl.FIRST..l_event_id_tbl.LAST
4501: UPDATE mtl_material_transactions
4502: SET costed_flag = NULL,
4503: last_update_date = sysdate,
4504: last_updated_by = p_user_id,
4505: last_update_login = p_login_id,

Line 4558: mtl_material_transactions mmt

4554: l_mmt_txn_id_tbl(i)
4555: FROM
4556: mtl_parameters mp,
4557: pjm_org_parameters pop,
4558: mtl_material_transactions mmt
4559: WHERE mmt.transaction_id = l_mmt_txn_id_tbl(i) --bug#14180892
4560: AND mp.organization_id = mmt.organization_id
4561: AND pop.organization_id (+) = mp.organization_id
4562: AND NVL(pop.pa_posting_flag,'N') <> 'Y'

Line 4733: FROM mtl_material_transactions mmt,

4729: -- been inserted into CCE, and should not be inserted into CRCML.
4730: BEGIN
4731: SELECT mmt.trx_source_line_id
4732: INTO l_cogs_om_line_id
4733: FROM mtl_material_transactions mmt,
4734: cst_cogs_events cce
4735: WHERE mmt.transaction_id = p_transaction_id
4736: AND cce.mmt_transaction_id = mmt.transaction_id;
4737: EXCEPTION

Line 7502: FROM mtl_material_transactions_temp mmtt, cst_revenue_cogs_match_lines crcml

7498: WHERE mti.trx_source_line_id = crcml.cogs_om_line_id
7499: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7500: UNION
7501: SELECT 1
7502: FROM mtl_material_transactions_temp mmtt, cst_revenue_cogs_match_lines crcml
7503: WHERE mmtt.trx_source_line_id = crcml.cogs_om_line_id
7504: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7505: UNION
7506: SELECT 1

Line 7507: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml

7503: WHERE mmtt.trx_source_line_id = crcml.cogs_om_line_id
7504: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7505: UNION
7506: SELECT 1
7507: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml
7508: WHERE mmt.trx_source_line_id = crcml.cogs_om_line_id
7509: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7510: AND mmt.cogs_recognition_percent is null
7511: AND mmt.so_issue_account_type = 2

Line 7516: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml

7512: AND mmt.transaction_type_id = 33
7513: AND Nvl(mmt.logical_transactions_created,2)=2
7514: UNION
7515: SELECT 1
7516: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml
7517: WHERE mmt.trx_source_line_id = crcml.cogs_om_line_id
7518: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7519: AND mmt.cogs_recognition_percent IS null
7520: AND mmt.so_issue_account_type = 2

Line 7539: FROM mtl_material_transactions_temp mmtt, cst_revenue_cogs_match_lines crcml

7535: WHERE mti.trx_source_line_id = crcml.cogs_om_line_id
7536: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7537: UNION
7538: SELECT 1
7539: FROM mtl_material_transactions_temp mmtt, cst_revenue_cogs_match_lines crcml
7540: WHERE mmtt.trx_source_line_id = crcml.cogs_om_line_id
7541: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7542: UNION
7543: SELECT 1

Line 7544: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml

7540: WHERE mmtt.trx_source_line_id = crcml.cogs_om_line_id
7541: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7542: UNION
7543: SELECT 1
7544: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml
7545: WHERE mmt.trx_source_line_id = crcml.cogs_om_line_id
7546: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7547: AND mmt.cogs_recognition_percent is null
7548: AND mmt.so_issue_account_type = 2

Line 7553: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml

7549: AND mmt.transaction_type_id = 33
7550: AND Nvl(mmt.logical_transactions_created,2)=2
7551: UNION
7552: SELECT 1
7553: FROM mtl_material_transactions mmt, cst_revenue_cogs_match_lines crcml
7554: WHERE mmt.trx_source_line_id = crcml.cogs_om_line_id
7555: AND crcml.revenue_om_line_id=crrl.revenue_om_line_id
7556: AND mmt.cogs_recognition_percent IS null
7557: AND mmt.so_issue_account_type = 2