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_S

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

1079: opm_org_flag,
1080: acct_period_id
1081: )
1082: SELECT cst_cogs_events_s.nextval,
1083: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1084: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1085: NULL),
1086: cce.cogs_om_line_id,
1087: l_rma_om_line_id_tbl(i),

Line 1084: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,

1080: acct_period_id
1081: )
1082: SELECT cst_cogs_events_s.nextval,
1083: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
1084: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
1085: NULL),
1086: cce.cogs_om_line_id,
1087: l_rma_om_line_id_tbl(i),
1088: cce.event_date,

Line 1995: mtl_material_transactions_s.nextval,

1991: --untouch to avoid breaking the current logic based on the CCE,CRCML,CRRL for CCE creation
1992: --If the problem is hitting the accounting unproper such as to much COGS recognized or not enough
1993: --this can be the starting point
1994: nvl(l_alternate_event_date+.99999+l_date_offset_tbl(i),l_event_date_tbl(i)),
1995: mtl_material_transactions_s.nextval,
1996: l_new_percentage_tbl(i),
1997: l_prior_percentage_tbl(i),
1998: l_prior_event_id_tbl(i),
1999: COGS_RECOGNITION_EVENT,

Line 2155: mtl_material_transactions_s.nextval,

2151: opm_org_flag,
2152: acct_period_id
2153: )
2154: SELECT cst_cogs_events_s.nextval,
2155: mtl_material_transactions_s.nextval,
2156: cogs_om_line_id,
2157: event_date,
2158: l_prior_percentage_tbl(i), -- could also use cce.prior_cogs_percentage
2159: l_new_percentage_tbl(i),

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

3136: opm_org_flag,
3137: acct_period_id
3138: )
3139: SELECT cst_cogs_events_s.nextval,
3140: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3141: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3142: NULL),
3143: cce.cogs_om_line_id,
3144: p_rma_om_line_id,

Line 3141: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,

3137: acct_period_id
3138: )
3139: SELECT cst_cogs_events_s.nextval,
3140: decode(event_type, COGS_RECOGNITION_EVENT, mtl_material_transactions_s.nextval,
3141: COGS_REC_PERCENT_ADJUSTMENT, mtl_material_transactions_s.nextval,
3142: NULL),
3143: cce.cogs_om_line_id,
3144: p_rma_om_line_id,
3145: cce.event_date,