DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on MTL_TRANSACTION_ACCOUNTS

Line 2121: mtl_transaction_accounts MTA /*,

2117: MMT.subinventory_code),
2118: MMT.inventory_item_id,
2119: SUM(MTA.base_transaction_value)
2120: FROM mtl_material_transactions MMT,
2121: mtl_transaction_accounts MTA /*,
2122: mtl_secondary_inventories SUB */
2123: WHERE MTA.accounting_line_type = 1 -- inventory
2124: AND MTA.transaction_date >= l_period_start_date
2125: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))

Line 2194: mtl_transaction_accounts MTA /*,

2190: MMT.transfer_subinventory,
2191: MMT.inventory_item_id,
2192: SUM(MTA.base_transaction_value)
2193: FROM mtl_material_transactions MMT,
2194: mtl_transaction_accounts MTA /*,
2195: mtl_secondary_inventories SUB */
2196: WHERE MTA.accounting_line_type = 1 -- inventory
2197: AND MTA.transaction_date >= l_period_start_date
2198: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))

Line 2246: mtl_transaction_accounts MTA

2242: NULL,
2243: MMT.inventory_item_id,
2244: SUM(MTA.base_transaction_value)
2245: FROM mtl_material_transactions MMT,
2246: mtl_transaction_accounts MTA
2247: WHERE MTA.accounting_line_type = 14 -- intransit account
2248: AND MTA.transaction_date >= l_period_start_date
2249: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))
2250: AND MTA.organization_id = p_org_id