DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

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 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 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,