DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1999: mtl_transaction_accounts MTA /*,

1995: MMT.subinventory_code),
1996: MMT.inventory_item_id,
1997: SUM(MTA.base_transaction_value)
1998: FROM mtl_material_transactions MMT,
1999: mtl_transaction_accounts MTA /*,
2000: mtl_secondary_inventories SUB */
2001: WHERE MTA.accounting_line_type = 1 -- inventory
2002: AND MTA.transaction_date >= l_period_start_date
2003: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))

Line 2069: mtl_transaction_accounts MTA /*,

2065: MMT.transfer_subinventory,
2066: MMT.inventory_item_id,
2067: SUM(MTA.base_transaction_value)
2068: FROM mtl_material_transactions MMT,
2069: mtl_transaction_accounts MTA /*,
2070: mtl_secondary_inventories SUB */
2071: WHERE MTA.accounting_line_type = 1 -- inventory
2072: AND MTA.transaction_date >= l_period_start_date
2073: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))

Line 2115: mtl_transaction_accounts MTA

2111: NULL,
2112: MMT.inventory_item_id,
2113: SUM(MTA.base_transaction_value)
2114: FROM mtl_material_transactions MMT,
2115: mtl_transaction_accounts MTA
2116: WHERE MTA.accounting_line_type = 14 -- intransit account
2117: AND MTA.transaction_date >= l_period_start_date
2118: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))
2119: AND MTA.organization_id = p_org_id