[Home] [Help]
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)
613: /* do not pick up physical SO issue in a drop shipment flow */
614: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)
787: oe_order_lines_all ool,
788: cst_revenue_cogs_match_lines crcml,
789: cst_cogs_events cce,
790: mtl_secondary_inventories msi,
791: mtl_system_items_b item
792: ,cst_acct_info_v caiv --BUG#7463298
793: WHERE mmt.transaction_source_type_id = 12
794: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below
795: AND (mmt.costed_flag = 'N' OR mmt.opm_costed_flag = 'N')
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)
1107: AND cce.event_date > l_txn_date_tbl(i)
1108: AND cce.event_id = cce.parent_event_id
1109: AND cce.cogs_om_line_id = crcml.cogs_om_line_id
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
1415: ,mtl_material_transactions mmt
1416: --}
1417: WHERE crrl.ledger_id = p_sob_id
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
3164: AND cce.event_date > p_transaction_date
3165: AND cce.event_id = cce.parent_event_id
3166: AND cce.cogs_om_line_id = crcml.cogs_om_line_id
5996: CRCML.UNIT_COST,
5997: CRCML.COGS_ACCT_ID,
5998: CRCML.DEFERRED_COGS_ACCT_ID
5999: ) Q,
6000: MTL_SYSTEM_ITEMS_KFV MSI,
6001: gl_code_combinations_kfv cogs_acct,
6002: gl_code_combinations_kfv dcogs_acct,
6003: ra_customer_trx_lines_all srclines,
6004: HZ_CUST_ACCOUNTS cust_acct,
6209: CRCML.UNIT_COST,
6210: CRCML.COGS_ACCT_ID,
6211: CRCML.DEFERRED_COGS_ACCT_ID
6212: ) Q,
6213: MTL_SYSTEM_ITEMS_KFV MSI,
6214: gl_code_combinations_kfv cogs_acct,
6215: gl_code_combinations_kfv dcogs_acct,
6216: ra_customer_trx_lines_all srclines,
6217: HZ_CUST_ACCOUNTS cust_acct,