DBA Data[Home] [Help]

APPS.CSP_USAGE_HISTORIES_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 43: from mtl_material_transactions mmt,

39: mmt.organization_id,
40: trunc(sysdate) - round((to_number(trunc(sysdate) - mmt.transaction_date)/l_period_size+0.5)) * l_period_size period_start_date,
41: mmt.subinventory_code,
42: sum(mmt.primary_quantity) * -1 primary_quantity
43: from mtl_material_transactions mmt,
44: csp_sec_inventories csi
45: where csi.parts_loop_id = l_parts_loop_id
46: and mmt.subinventory_code = csi.secondary_inventory_name
47: and mmt.organization_id = csi.organization_id