APPS.INV_LABEL_PVT1 dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 514: , mtl_transaction_lots_temp mtlt

510: , rti.DEPARTMENT_CODE
511: , rti.BOM_RESOURCE_ID
512: FROM rcv_transactions_interface rti
513: , wip_osp_jobs_val_v wojv
514: , mtl_transaction_lots_temp mtlt
515: , /***************************************/
516: (SELECT rti.GROUP_ID
517: , rti.interface_transaction_id
518: , rti.to_organization_id organization_id

Line 1273: ,mtl_transaction_lots_temp mtlt

1269: , mtlt.hold_date
1270: , mtlt.expiration_action_code
1271: , mtlt.supplier_lot_number -- invconv end
1272: FROM mtl_material_transactions_temp mmtt
1273: ,mtl_transaction_lots_temp mtlt
1274: ,wip_entities we -- Fix For Bug: 4907062
1275: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1276: AND mmtt.transaction_temp_id = p_transaction_id
1277: AND we.wip_entity_id(+) = mmtt.transaction_source_id; -- Fix For Bug: 4907062

Line 1303: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1299: , mmtt.locator_id
1300: , mmtt.transfer_to_location
1301: , mmtt.secondary_uom_code -- added for invconv
1302: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) -- added for invconv
1303: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1304: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1305: AND mmtt.transaction_temp_id = p_transaction_id
1306: AND mmtt.content_lpn_id IS NULL
1307: UNION ALL

Line 1351: , mtl_transaction_lots_temp mtlt

1347: , mmtt.revision revision
1348: , mmtt.transfer_subinventory
1349: , mmtt.transfer_to_location
1350: FROM mtl_material_transactions_temp mmtt
1351: , mtl_transaction_lots_temp mtlt
1352: , mtl_material_transactions_temp mmtt_orgin
1353: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1354: AND mmtt.transaction_header_id = mmtt_orgin.transaction_header_id
1355: AND mmtt.transaction_temp_id <> mmtt_orgin.transaction_temp_id

Line 1372: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1368: , mmtt.SECONDARY_UOM_CODE secondary_uom -- fabdi bug 4387144
1369: , mmtt.revision revision
1370: , mmtt.transfer_subinventory
1371: , mmtt.transfer_to_location
1372: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1373: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1374: AND mmtt.content_lpn_id IS NULL
1375: AND mmtt.transaction_temp_id = p_transaction_id;
1376:

Line 1398: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1394: , mmtt.locator_id
1395: , mmtt.transfer_to_location
1396: , ABS(NVL(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv changes
1397: , mmtt.secondary_uom_code -- invconv changes
1398: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1399: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1400: AND mmtt.transfer_lpn_id IS NULL
1401: AND mmtt.content_lpn_id IS NULL
1402: AND mmtt.transaction_temp_id = p_transaction_id

Line 1489: , mtl_transaction_lots_temp mtlt

1485: , mmtt.revision
1486: , mtlt.lot_number
1487: , SUM(mmtt.primary_quantity) quantity
1488: FROM mtl_material_transactions_temp mmtt
1489: , mtl_transaction_lots_temp mtlt
1490: WHERE mmtt.cartonization_id = p_transaction_id
1491: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1492: GROUP BY mmtt.organization_id
1493: , mmtt.inventory_item_id

Line 1565: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1561: , mmtt.transaction_uom
1562: , mmtt.revision
1563: , mmtt.subinventory_code
1564: , mmtt.locator_id
1565: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1566: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1567: AND mmtt.transaction_temp_id = p_transaction_id;
1568: */
1569: -- For business_flow_code of Manufacturing Cross-Dock

Line 1582: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1578: , mmtt.transaction_uom
1579: , mmtt.revision
1580: , mmtt.subinventory_code
1581: , mmtt.locator_id
1582: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1583: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1584: AND mmtt.transaction_temp_id = p_transaction_id;
1585:
1586: -- For business flow code of 33, the MMTT, MTI or MOL id is passed

Line 1602: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1598: , mmtt.transaction_uom uom
1599: , mmtt.revision revision
1600: , mmtt.subinventory_code
1601: , mmtt.locator_id
1602: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1603: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1604: AND mmtt.transaction_temp_id = p_transaction_id;
1605:
1606: CURSOR flow_material_curs_mti IS

Line 2832: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2828: ELSE
2829: --bug 6646793
2830: if (l_transaction_type = 82 and p_label_type_info.business_flow_code = 12)then
2831: select nvl (mmtt.transaction_quantity,mtlt.transaction_quantity) into l_mmtt_quantity
2832: from mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2833: where mmtt.transaction_temp_id = p_transaction_id
2834: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2835:
2836: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity

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

2833: where mmtt.transaction_temp_id = p_transaction_id
2834: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2835:
2836: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity
2837: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2838: WHERE mmtt.transaction_temp_id = p_transaction_id
2839: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
2840: and moqd.lot_number = mtlt.lot_number
2841: and nvl(mmtt.lpn_id , -999) = nvl(moqd.lpn_id , -999)