APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SYSTEM_ITEMS

Line 661: mtl_system_items_b item

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
663: WHERE mmt.transaction_action_id in (1,7)
664: /* do not pick up physical SO issue in a drop shipment flow */
665: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)

Line 698: mtl_system_items_b item

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
700: WHERE mmt.transaction_action_id in (1,7)
701: /* do not pick up physical SO issue in a drop shipment flow */
702: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)

Line 881: mtl_system_items_b item

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
882: ,cst_acct_info_v caiv --BUG#7463298
883: ,mtl_parameters mp --BUG#9306124
884: WHERE mmt.transaction_source_type_id = 12
885: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below

Line 949: mtl_system_items_b item

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
950: ,cst_acct_info_v caiv --BUG#7463298
951: ,mtl_parameters mp --BUG#9306124
952: WHERE mmt.transaction_source_type_id = 12
953: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below

Line 1283: mtl_system_items msi

1279: cst_revenue_cogs_match_lines crcml,
1280: mtl_parameters mp,
1281: org_acct_periods oap,
1282: cst_acct_info_v caiv,
1283: mtl_system_items msi
1284: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)
1285: AND TRUNC(cce.event_date) > l_txn_date_tbl(i)
1286: AND cce.event_type IN (3,4)
1287: AND cce.event_id = cce.parent_event_id

Line 1596: mtl_system_items msi

1592: cst_cogs_events cce,
1593: mtl_parameters mp,
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

Line 3186: mtl_system_items msi

3182: cst_revenue_cogs_match_lines crcml,
3183: mtl_parameters mp,
3184: org_acct_periods oap,
3185: cst_acct_info_v caiv,
3186: mtl_system_items msi
3187: WHERE cce.cogs_om_line_id = p_cogs_om_line_id
3188: AND cce.event_date > p_transaction_date
3189: AND cce.event_id = cce.parent_event_id
3190: AND cce.cogs_om_line_id = crcml.cogs_om_line_id

Line 6166: MTL_SYSTEM_ITEMS_KFV MSI,

6162: CRCML.ORGANIZATION_ID,
6163: CRCML.COGS_ACCT_ID,
6164: CRCML.DEFERRED_COGS_ACCT_ID
6165: ) Q2,
6166: MTL_SYSTEM_ITEMS_KFV MSI,
6167: gl_code_combinations_kfv cogs_acct,
6168: gl_code_combinations_kfv dcogs_acct,
6169: ra_customer_trx_lines_all srclines,
6170: HZ_CUST_ACCOUNTS cust_acct,

Line 6502: MTL_SYSTEM_ITEMS_KFV MSI,

6498: CRCML.UNIT_COST,
6499: CRCML.COGS_ACCT_ID,
6500: CRCML.DEFERRED_COGS_ACCT_ID
6501: ) Q,
6502: MTL_SYSTEM_ITEMS_KFV MSI,
6503: gl_code_combinations_kfv cogs_acct,
6504: gl_code_combinations_kfv dcogs_acct,
6505: ra_customer_trx_lines_all srclines,
6506: HZ_CUST_ACCOUNTS cust_acct,