eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_WS_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1882: and exists (select 1 from mtl_material_transactions mmt

1878: and mtln.parent_object_number = p_assy_serial
1879: and mtln.parent_item_id = p_assy_item_id
1880: and mtln.organization_id= p_org_id
1881: and mtln.inventory_item_id = p_comp_item_id
1882: and exists (select 1 from mtl_material_transactions mmt
1883: where mmt.transaction_id = mtln.transaction_id
1884: and mmt.transaction_source_type_id = mtln.transaction_source_type_id
1885: and mmt.transaction_source_id = mtln.transaction_source_id
1886: and mmt.organization_id = mtln.organization_id

Line 1903: and exists (select 1 from mtl_material_transactions mmt

1899: and mut.parent_item_id = p_assy_item_id
1900: and mut.organization_id= p_org_id
1901: and mut.receipt_issue_type in (1,2)
1902: and mut.inventory_item_id = p_comp_item_id
1903: and exists (select 1 from mtl_material_transactions mmt
1904: where mmt.transaction_id = mut.transaction_id
1905: and mmt.transaction_source_type_id = mut.transaction_source_type_id
1906: and mmt.transaction_source_id = mut.transaction_source_id
1907: and mmt.organization_id = mut.organization_id