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.INV_LABEL_PVT1 dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 521: , mtl_transaction_lots_temp mtlt

517: , rti.DEPARTMENT_CODE
518: , rti.BOM_RESOURCE_ID
519: FROM rcv_transactions_interface rti
520: , wip_osp_jobs_val_v wojv
521: , mtl_transaction_lots_temp mtlt
522: , /***************************************/
523: (SELECT rti.GROUP_ID
524: , rti.interface_transaction_id
525: , rti.to_organization_id organization_id

Line 1317: ,mtl_transaction_lots_temp mtlt

1313: , mtlt.expiration_action_code
1314: , mtlt.supplier_lot_number -- invconv end
1315: , mtlt.lot_expiration_date --bug13936282
1316: FROM mtl_material_transactions_temp mmtt
1317: ,mtl_transaction_lots_temp mtlt
1318: ,wip_entities we -- Fix For Bug: 4907062
1319: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1320: AND mmtt.transaction_temp_id = p_transaction_id
1321: AND we.wip_entity_id(+) = mmtt.transaction_source_id; -- Fix For Bug: 4907062

Line 1347: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1343: , mmtt.locator_id
1344: , mmtt.transfer_to_location
1345: , mmtt.secondary_uom_code -- added for invconv
1346: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) -- added for invconv
1347: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1348: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1349: AND mmtt.transaction_temp_id = p_transaction_id
1350: AND mmtt.content_lpn_id IS NULL
1351: UNION ALL

Line 1395: , mtl_transaction_lots_temp mtlt

1391: , mmtt.revision revision
1392: , mmtt.transfer_subinventory
1393: , mmtt.transfer_to_location
1394: FROM mtl_material_transactions_temp mmtt
1395: , mtl_transaction_lots_temp mtlt
1396: , mtl_material_transactions_temp mmtt_orgin
1397: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1398: AND mmtt.transaction_header_id = mmtt_orgin.transaction_header_id
1399: AND mmtt.transaction_temp_id <> mmtt_orgin.transaction_temp_id

Line 1416: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1412: , mmtt.SECONDARY_UOM_CODE secondary_uom -- fabdi bug 4387144
1413: , mmtt.revision revision
1414: , mmtt.transfer_subinventory
1415: , mmtt.transfer_to_location
1416: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1417: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1418: AND mmtt.content_lpn_id IS NULL
1419: AND mmtt.transaction_temp_id = p_transaction_id;
1420:

Line 1442: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1438: , mmtt.locator_id
1439: , mmtt.transfer_to_location
1440: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv changes
1441: , mmtt.secondary_uom_code -- invconv changes
1442: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1443: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1444: AND mmtt.transfer_lpn_id IS NULL
1445: AND mmtt.content_lpn_id IS NULL
1446: AND mmtt.transaction_temp_id = p_transaction_id

Line 1533: , mtl_transaction_lots_temp mtlt

1529: , mmtt.revision
1530: , mtlt.lot_number
1531: , SUM(mmtt.primary_quantity) quantity
1532: FROM mtl_material_transactions_temp mmtt
1533: , mtl_transaction_lots_temp mtlt
1534: WHERE mmtt.cartonization_id = p_transaction_id
1535: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1536: GROUP BY mmtt.organization_id
1537: , mmtt.inventory_item_id

Line 1609: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1605: , mmtt.transaction_uom
1606: , mmtt.revision
1607: , mmtt.subinventory_code
1608: , mmtt.locator_id
1609: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1610: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1611: AND mmtt.transaction_temp_id = p_transaction_id;
1612: */
1613: -- For business_flow_code of Manufacturing Cross-Dock

Line 1629: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, wip_entities we --11682748 get wip entity info

1625: , mmtt.locator_id
1626: , we.wip_entity_id --11682748 get wip entity info
1627: , we.wip_entity_name --11682748 get wip entity info
1628: , we.description --11682748 get wip entity info
1629: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, wip_entities we --11682748 get wip entity info
1630: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1631: AND we.wip_entity_id(+)=mmtt.transaction_source_id --11682748 get wip entity info
1632: AND mmtt.transaction_temp_id = p_transaction_id; --11682748 get wip entity info
1633:

Line 1650: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1646: , mmtt.transaction_uom uom
1647: , mmtt.revision revision
1648: , mmtt.subinventory_code
1649: , mmtt.locator_id
1650: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1651: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1652: AND mmtt.transaction_temp_id = p_transaction_id;
1653:
1654: CURSOR flow_material_curs_mti IS

Line 2018: mtl_transaction_lots_temp mtlt ,

2014: ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) ,
2015: wipe.wip_entity_name,
2016: mmtt.trx_source_line_id
2017: FROM mtl_material_transactions_temp mmtt,
2018: mtl_transaction_lots_temp mtlt ,
2019: wip_entities wipe
2020: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
2021: AND mmtt.transaction_temp_id = p_transaction_id
2022: AND mmtt.transaction_source_id = wipe.wip_entity_id

Line 2981: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2977: --bug 6646793
2978: TRACE(' show the l_transaction_type: ' || l_transaction_type); --9464300
2979: if (l_transaction_type in (82,83) and p_label_type_info.business_flow_code = 12) then -- 9464300 split:82,merge:83 add one transaction_type 83
2980: select nvl (mmtt.transaction_quantity,mtlt.transaction_quantity) into l_mmtt_quantity
2981: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2982: where mmtt.transaction_temp_id = p_transaction_id
2983: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2984:
2985: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity

Line 2986: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2982: where mmtt.transaction_temp_id = p_transaction_id
2983: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2984:
2985: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity
2986: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2987: WHERE mmtt.transaction_temp_id = p_transaction_id
2988: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
2989: and moqd.lot_number = mtlt.lot_number
2990: and nvl(mmtt.lpn_id , -999) = nvl(moqd.lpn_id , -999)