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.

APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 996: FROM mtl_material_transactions_temp

992: l_progress VARCHAR2(10) := '0';
993:
994: CURSOR mmtt_cur IS
995: SELECT rowid, transaction_temp_id, transaction_quantity, transaction_uom
996: FROM mtl_material_transactions_temp
997: WHERE organization_id = p_organization_id
998: AND inventory_item_id = p_inventory_item_id
999: AND NVL(revision, '@') = NVL(p_revision, '@')
1000: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 1082: UPDATE mtl_material_transactions_temp

1078: IF ( p_lot_number IS NULL ) THEN
1079: l_progress := '400';
1080: IF ( p_secondary_quantity IS NULL ) THEN
1081: -- Caller wants to null out all secondary_quantity for this item
1082: UPDATE mtl_material_transactions_temp
1083: SET secondary_transaction_quantity = NULL,
1084: secondary_uom_code = NULL
1085: WHERE organization_id = p_organization_id
1086: AND inventory_item_id = p_inventory_item_id

Line 1121: UPDATE mtl_material_transactions_temp

1117: ELSE
1118: l_line_quantity := mmtt_rec.transaction_quantity;
1119: END IF;
1120:
1121: UPDATE mtl_material_transactions_temp
1122: SET secondary_transaction_quantity = round(p_secondary_quantity*(l_line_quantity/p_quantity), g_precision),
1123: secondary_uom_code = p_secondary_uom_code
1124: WHERE rowid = mmtt_rec.rowid;
1125:

Line 1141: FROM mtl_material_transactions_temp mmtt

1137: secondary_unit_of_measure = NULL
1138: WHERE lot_number = p_lot_number
1139: AND transaction_temp_id IN (
1140: SELECT transaction_temp_id
1141: FROM mtl_material_transactions_temp mmtt
1142: WHERE organization_id = p_organization_id
1143: AND inventory_item_id = p_inventory_item_id
1144: AND NVL(revision, '@') = NVL(p_revision, '@')
1145: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 1277: FROM mtl_material_transactions_temp

1273: ORDER BY msi.primary_uom_code, msi.secondary_uom_code;
1274:
1275: CURSOR mmtt_item_cur IS
1276: SELECT distinct inventory_item_id, organization_id
1277: FROM mtl_material_transactions_temp
1278: WHERE organization_id = p_organization_id
1279: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1280: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1281: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )

Line 1476: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1472: BEGIN
1473: SELECT 1 INTO l_temp FROM DUAL
1474: WHERE EXISTS (
1475: SELECT 1
1476: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1477: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
1478: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
1479: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1480: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

Line 1593: FROM mtl_material_transactions_temp mmtt,

1589: UNION
1590: SELECT UNIQUE wlpn.license_plate_number,
1591: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1592: wlpn.lpn_context
1593: FROM mtl_material_transactions_temp mmtt,
1594: wms_license_plate_numbers wlpn,
1595: mtl_system_items_b msi
1596: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1597: AND mmtt.organization_id = msi.organization_id

Line 1608: FROM mtl_material_transactions_temp mmtt,

1604: UNION
1605: SELECT UNIQUE wlpn.license_plate_number,
1606: transfer_lpn_id,
1607: wlpn.lpn_context
1608: FROM mtl_material_transactions_temp mmtt,
1609: wms_license_plate_numbers wlpn,
1610: mtl_system_items_b msi
1611: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1612: AND mmtt.organization_id = msi.organization_id

Line 1652: FROM mtl_material_transactions_temp mmtt, wms_license_plate_numbers wlpn,

1648: UNION
1649: SELECT UNIQUE wlpn.license_plate_number,
1650: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1651: wlpn.lpn_context
1652: FROM mtl_material_transactions_temp mmtt, wms_license_plate_numbers wlpn,
1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt
1654: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1655: AND mmtt.organization_id = msi.organization_id
1656: AND mmtt.organization_id = p_org_id

Line 1668: FROM mtl_material_transactions_temp mmtt,

1664: AND mtlt.secondary_quantity IS NULL
1665: UNION
1666: SELECT UNIQUE wlpn.license_plate_number,
1667: transfer_lpn_id, wlpn.lpn_context
1668: FROM mtl_material_transactions_temp mmtt,
1669: wms_license_plate_numbers wlpn,
1670: mtl_system_items_b msi,
1671: mtl_transaction_lots_temp mtlt
1672: WHERE mmtt.inventory_item_id = msi.inventory_item_id

Line 1739: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,

1735: AND msi.ont_pricing_qty_source = 'S'
1736: AND wlc.parent_lpn_id = wlpn.lpn_id)
1737: UNION
1738: SELECT distinct license_plate_number, content_lpn_id
1739: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,
1740: wms_license_plate_numbers wlpn
1741: WHERE (mmtt.content_lpn_id = p_outer_lpn_id
1742: OR mmtt.transfer_lpn_id = p_outer_lpn_id )
1743: AND mmtt.organization_id = p_org_id

Line 1753: mtl_material_transactions_temp mmtt,

1749: /*UNION
1750: SELECT distinct license_plate_number,
1751: transfer_lpn_id
1752: FROM mtl_system_items msi,
1753: mtl_material_transactions_temp mmtt,
1754: wms_license_plate_numbers wlpn
1755: WHERE (mmtt.content_lpn_id = p_outer_lpn_id
1756: OR mmtt.transfer_lpn_id = p_outer_lpn_id)
1757: AND mmtt.organization_id = p_org_id

Line 1769: ,mtl_material_transactions_temp mmtt

1765: IF (p_lpn_context = 8 OR p_lpn_context = 1) THEN --Packing
1766: OPEN x_lpn_lov FOR
1767: SELECT distinct wlpn.license_plate_number, content_lpn_id
1768: FROM mtl_system_items msi
1769: ,mtl_material_transactions_temp mmtt
1770: ,wms_license_plate_numbers wlpn
1771: ,mtl_transaction_lots_temp mtlt
1772: WHERE mmtt.content_lpn_id = p_outer_lpn_id
1773: AND mmtt.organization_id = p_org_id

Line 1784: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

1780: AND mtlt.secondary_quantity IS NULL
1781: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
1782: UNION
1783: SELECT distinct wlpn.license_plate_number, content_lpn_id
1784: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
1785: ,wms_license_plate_numbers wlpn
1786: ,mtl_transaction_lots_temp mtlt
1787: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
1788: AND mmtt.organization_id = p_org_id

Line 1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

1994: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1995: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
1999: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2000: AND mmtt.organization_id = p_org_id
2001: AND mmtt.organization_id = msi.organization_id
2002: AND msi.ont_pricing_qty_source = 'S'

Line 2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

2050: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2051: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
2055: where (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2056: and mmtt.organization_id = p_org_id
2057: and mmtt.organization_id = msi.organization_id
2058: and mmtt.inventory_item_id = msi.inventory_item_id