APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1006: FROM mtl_transaction_lots_temp

1002: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
1003:
1004: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS
1005: SELECT rowid, transaction_quantity
1006: FROM mtl_transaction_lots_temp
1007: WHERE transaction_temp_id = p_trx_temp_id
1008: AND lot_number = p_lot_number;
1009:
1010: l_del_det_id NUMBER;

Line 1135: UPDATE mtl_transaction_lots_temp

1131: ELSE -- p_lot_number is not null
1132: l_progress := '600';
1133: IF ( p_secondary_quantity IS NULL ) THEN
1134: -- Caller wants to null out all secondary_quantity for this lot
1135: UPDATE mtl_transaction_lots_temp
1136: SET secondary_quantity = NULL,
1137: secondary_unit_of_measure = NULL
1138: WHERE lot_number = p_lot_number
1139: AND transaction_temp_id IN (

Line 1183: UPDATE mtl_transaction_lots_temp

1179: ELSE
1180: l_line_quantity := mtlt_rec.transaction_quantity;
1181: END IF;
1182:
1183: UPDATE mtl_transaction_lots_temp
1184: SET secondary_quantity = round(p_secondary_quantity*(l_line_quantity/p_quantity), g_precision),
1185: secondary_unit_of_measure = p_secondary_uom_code
1186: WHERE rowid = mtlt_rec.rowid;
1187:

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 1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt

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
1657: AND msi.ont_pricing_qty_source = 'S'

Line 1671: mtl_transaction_lots_temp mtlt

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
1673: AND mmtt.organization_id = msi.organization_id
1674: AND mmtt.organization_id = p_org_id
1675: AND wlpn.lpn_id = mmtt.transfer_lpn_id

Line 1771: ,mtl_transaction_lots_temp mtlt

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
1774: AND mmtt.organization_id = msi.organization_id
1775: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 1786: ,mtl_transaction_lots_temp mtlt

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
1789: AND mmtt.organization_id = msi.organization_id
1790: AND mmtt.inventory_item_id = msi.inventory_item_id