SELECT ood.organization_code,
mmt.inventory_item_id Item_id,
msi.segment1 item_name,
mmt.creation_date,
mmt.transaction_quantity,
mmt.transaction_date,
mtt.transaction_type_name,
mmt.*
FROM mtl_material_transactions mmt,
mtl_system_items msi,
mtl_transaction_types mtt,
org_organization_definitions ood
WHERE msi.inventory_item_id = mmt.inventory_item_id
and mmt.organization_id = ood.organization_id
AND mmt.organization_id = msi.organization_id
AND mmt.transaction_type_id IN (100001, 100002)
AND mtt.transaction_type_id = mmt.transaction_type_id
AND TRUNC (mmt.transaction_date) BETWEEN :f AND :t
AND mmt.organization_id = 81
ORDER BY mmt.transaction_date
mmt.inventory_item_id Item_id,
msi.segment1 item_name,
mmt.creation_date,
mmt.transaction_quantity,
mmt.transaction_date,
mtt.transaction_type_name,
mmt.*
FROM mtl_material_transactions mmt,
mtl_system_items msi,
mtl_transaction_types mtt,
org_organization_definitions ood
WHERE msi.inventory_item_id = mmt.inventory_item_id
and mmt.organization_id = ood.organization_id
AND mmt.organization_id = msi.organization_id
AND mmt.transaction_type_id IN (100001, 100002)
AND mtt.transaction_type_id = mmt.transaction_type_id
AND TRUNC (mmt.transaction_date) BETWEEN :f AND :t
AND mmt.organization_id = 81
ORDER BY mmt.transaction_date
No comments:
Post a Comment