[Home] [Help]
604: mmt.transaction_date,
605: mmt.cost_group_id,
606: (-1*mmt.primary_quantity) quantity
607: FROM mtl_material_transactions mmt,
608: mtl_parameters mp,
609: mtl_secondary_inventories msi,
610: mtl_system_items_b item
611: ,cst_acct_info_v caiv --BUG#7463298
612: WHERE mmt.transaction_action_id in (1,7)
1098: nvl(mp.process_enabled_flag,'N'),
1099: oap.acct_period_id -- acct period ID, I should store this in CCE so I don't keep having to go back to OAP
1100: FROM cst_cogs_events cce,
1101: cst_revenue_cogs_match_lines crcml,
1102: mtl_parameters mp,
1103: org_acct_periods oap,
1104: cst_acct_info_v caiv,
1105: mtl_system_items msi
1106: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)
1406: --}
1407: FROM cst_revenue_cogs_match_lines crcml,
1408: cst_revenue_recognition_lines crrl,
1409: cst_cogs_events cce,
1410: mtl_parameters mp,
1411: gl_period_statuses gps,
1412: cst_lists_temp clt,
1413: mtl_system_items msi
1414: --{BUG#6809034
3155: nvl(mp.process_enabled_flag,'N'),
3156: oap.acct_period_id
3157: FROM cst_cogs_events cce,
3158: cst_revenue_cogs_match_lines crcml,
3159: mtl_parameters mp,
3160: org_acct_periods oap,
3161: cst_acct_info_v caiv,
3162: mtl_system_items msi
3163: WHERE cce.cogs_om_line_id = p_cogs_om_line_id
4153: sob.currency_code,
4154: NVL(mmt.transaction_source_id, -1)
4155: FROM cst_cogs_events cce,
4156: cst_revenue_cogs_match_lines crcml,
4157: mtl_parameters mp,
4158: gl_sets_of_books sob,
4159: mtl_material_transactions mmt -- joining here to use the index on costed_flag
4160: WHERE
4161: cce.mmt_transaction_id = mmt.transaction_id
4486: l_event_date_tbl(i),
4487: l_le_date_tbl(i),
4488: l_mmt_txn_id_tbl(i)
4489: FROM
4490: mtl_parameters mp,
4491: pjm_org_parameters pop
4492: WHERE mp.organization_id = l_organization_id_tbl(i)
4493: AND pop.organization_id (+) = mp.organization_id
4494: AND NVL(pop.pa_posting_flag,'N') <> 'Y';