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_MATERIAL_TRANSACTIONS_TEMP

Line 114: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

110: , x_msg_data OUT NOCOPY VARCHAR2
111: , x_return_status OUT NOCOPY VARCHAR2
112: , p_label_type_info IN inv_label.label_type_rec
113: , p_transaction_id IN NUMBER
114: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
115: , p_transaction_identifier IN NUMBER
116: ) IS
117: -- Fix for 4888701: Included the Precsion and Scale for the variable quatity.
118: --l_quantity NUMBER := 0;

Line 1316: FROM mtl_material_transactions_temp mmtt

1312: , mtlt.hold_date
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

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 1368: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1364: , mmtt.locator_id
1365: , mmtt.transfer_to_location
1366: , wlc.secondary_uom_code -- added for invconv
1367: , wlc.secondary_quantity -- added for invconv
1368: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1369: WHERE mmtt.transaction_temp_id = p_transaction_id
1370: AND mmtt.content_lpn_id IS NOT NULL
1371: AND mmtt.content_lpn_id = wlc.parent_lpn_id;
1372:

Line 1394: FROM mtl_material_transactions_temp mmtt

1390: , mmtt.SECONDARY_UOM_CODE secondary_uom -- fabdi bug 4387144
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

Line 1396: , mtl_material_transactions_temp mmtt_orgin

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
1400: AND mmtt_orgin.content_lpn_id IS NOT NULL

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 1464: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1460: , mmtt.locator_id
1461: , mmtt.transfer_to_location
1462: , wlc.secondary_quantity -- added for invconv
1463: , wlc.secondary_uom_code -- added for invconv
1464: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1465: WHERE mmtt.transaction_temp_id = p_transaction_id
1466: AND mmtt.content_lpn_id = wlc.parent_lpn_id
1467: UNION ALL
1468: -- This part of the cursor is for 2 cases. Items unpacked from an LPN and packed into another LPN AND

Line 1485: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1481: , mmtt.locator_id
1482: , mmtt.transfer_to_location
1483: , wlc.secondary_quantity -- added for invconv
1484: , wlc.secondary_uom_code -- added for invconv
1485: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1486: WHERE mmtt.transaction_temp_id = p_transaction_id
1487: AND mmtt.transfer_lpn_id = wlc.parent_lpn_id
1488: UNION ALL
1489: -- This part of the cursor is for all cases except loose items being packed into an existing/new LPN.

Line 1505: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1501: , mmtt.locator_id
1502: , mmtt.transfer_to_location
1503: , wlc.secondary_quantity -- added for invconv
1504: , wlc.secondary_uom_code -- added for invconv
1505: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1506: WHERE mmtt.transaction_temp_id = p_transaction_id
1507: AND mmtt.lpn_id = wlc.parent_lpn_id;
1508:
1509: -- Packaging/Cartonization Cursors

Line 1532: FROM mtl_material_transactions_temp mmtt

1528: , mmtt.inventory_item_id
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

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 1989: mtl_material_transactions_temp mmtt

1985: ppf.full_name requestor
1986: FROM mtl_cycle_count_headers mcch,
1987: mtl_cycle_count_entries mcce,
1988: per_people_f ppf,
1989: mtl_material_transactions_temp mmtt
1990: WHERE mmtt.transaction_temp_id= p_transaction_id
1991: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1992: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1993: AND ppf.person_id(+) = mcce.counted_by_employee_id_current;

Line 2017: FROM mtl_material_transactions_temp mmtt,

2013: mmtt.secondary_uom_code,
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

Line 2046: mtl_material_transactions_temp mmtt,

2042: wlc.secondary_quantity ,
2043: wipe.wip_entity_name ,
2044: mmtt.trx_source_line_id
2045: FROM wms_lpn_contents wlc ,
2046: mtl_material_transactions_temp mmtt,
2047: wip_entities wipe
2048: WHERE mmtt.transaction_temp_id = p_transaction_id
2049: AND mmtt.transaction_source_id = wipe.wip_entity_id
2050: AND mmtt.content_lpn_id IS NOT NULL

Line 2948: from mtl_material_transactions_temp

2944: (/*8,*/ 9, 11, 12, 14, 19, 18, 22, 23, 27, 28, 34)--Bug 5928736 - Removed business flow 7, Bug 9525123 - Removed busines flow 29
2945: OR (p_label_type_info.business_flow_code = 8 AND p_transaction_identifier = 5)
2946: THEN
2947: select transaction_type_id into l_transaction_type
2948: from mtl_material_transactions_temp
2949: where transaction_temp_id = p_transaction_id; --bug 6646793
2950:
2951: OPEN mmtt_material_cur;
2952: FETCH mmtt_material_cur INTO l_inventory_item_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)

Line 5968: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

5964: , x_msg_data OUT NOCOPY VARCHAR2
5965: , x_return_status OUT NOCOPY VARCHAR2
5966: , p_label_type_info IN inv_label.label_type_rec
5967: , p_transaction_id IN NUMBER
5968: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
5969: , p_transaction_identifier IN NUMBER
5970: ) IS
5971: l_variable_data_tbl inv_label.label_tbl_type;
5972: BEGIN