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 1133: INSERT INTO mtl_material_transactions_temp(

1129: ', l_orig_lpn_ctx: ' || l_orig_lpn_ctx
1130: , 4);
1131: END IF;
1132:
1133: INSERT INTO mtl_material_transactions_temp(
1134: transaction_header_id
1135: , transaction_temp_id
1136: , last_update_date
1137: , last_updated_by

Line 1411: FROM mtl_material_transactions_temp mmtt

1407:
1408: CURSOR c_lpn_lot_pri_qty IS
1409: SELECT SUM(mtlt.primary_quantity)
1410: , SUM(mtlt.secondary_quantity)
1411: FROM mtl_material_transactions_temp mmtt
1412: , mtl_transaction_lots_temp mtlt
1413: WHERE (mmtt.content_lpn_id = p_lpn_id
1414: OR mmtt.transfer_lpn_id = p_lpn_id)
1415: AND mmtt.inventory_item_id = p_inventory_item_id

Line 1424: FROM mtl_material_transactions_temp mmtt

1420:
1421: CURSOR c_lpn_pri_qty IS
1422: SELECT SUM(mmtt.primary_quantity)
1423: , SUM(mmtt.secondary_transaction_quantity)
1424: FROM mtl_material_transactions_temp mmtt
1425: WHERE (mmtt.content_lpn_id = p_lpn_id
1426: OR mmtt.transfer_lpn_id = p_lpn_id)
1427: AND mmtt.inventory_item_id = p_inventory_item_id
1428: AND mmtt.parent_line_id IS NULL

Line 1441: FROM mtl_material_transactions_temp mmtt

1437: , mmtt.reservation_id
1438: , mmtt.move_order_line_id
1439: , mtlt.primary_quantity
1440: , mtlt.secondary_quantity
1441: FROM mtl_material_transactions_temp mmtt
1442: , mtl_transaction_lots_temp mtlt
1443: WHERE (mmtt.content_lpn_id = p_lpn_id
1444: OR mmtt.transfer_lpn_id = p_lpn_id)
1445: AND mmtt.inventory_item_id = p_inventory_item_id

Line 1461: FROM mtl_material_transactions_temp mmtt

1457: , mmtt.reservation_id
1458: , mmtt.move_order_line_id
1459: , mmtt.primary_quantity
1460: , mmtt.secondary_transaction_quantity
1461: FROM mtl_material_transactions_temp mmtt
1462: WHERE (mmtt.content_lpn_id = p_lpn_id
1463: OR mmtt.transfer_lpn_id = p_lpn_id)
1464: AND mmtt.inventory_item_id = p_inventory_item_id
1465: AND mmtt.parent_line_id IS NULL

Line 1492: FROM mtl_material_transactions_temp mmtt

1488: l_rsv_dtl_rec c_get_rsv_dtl%ROWTYPE;
1489:
1490: CURSOR c_lot_rsv_qty(p_rsv_id IN NUMBER) IS
1491: SELECT NVL(SUM(mtlt.primary_quantity),0)
1492: FROM mtl_material_transactions_temp mmtt
1493: , mtl_transaction_lots_temp mtlt
1494: , mtl_lot_numbers mln
1495: , mtl_secondary_inventories msi
1496: , mtl_item_locations mil

Line 1513: FROM mtl_material_transactions_temp mmtt

1509: AND NVL(mil.reservable_type,1) = 1;
1510:
1511: CURSOR c_rsv_qty(p_rsv_id IN NUMBER) IS
1512: SELECT NVL(SUM(mmtt.primary_quantity),0)
1513: FROM mtl_material_transactions_temp mmtt
1514: , mtl_secondary_inventories msi
1515: , mtl_item_locations mil
1516: WHERE mmtt.reservation_id = p_rsv_id
1517: AND msi.organization_id = mmtt.organization_id

Line 1526: FROM mtl_material_transactions_temp mmtt

1522: AND NVL(mil.reservable_type,1) = 1;
1523:
1524: CURSOR c_onh_stat_rsv_qty(p_rsv_id IN NUMBER) IS
1525: SELECT NVL(SUM(mmtt.primary_quantity),0)
1526: FROM mtl_material_transactions_temp mmtt
1527: WHERE mmtt.reservation_id = p_rsv_id
1528: AND EXISTS ( SELECT 'x'
1529: FROM mtl_onhand_quantities_detail moqd
1530: , mtl_material_statuses mms

Line 2746: UPDATE mtl_material_transactions_temp

2742: WHERE transaction_temp_id = t_temp_id(i)
2743: AND lot_number = p_lot_number;
2744: END IF;
2745:
2746: UPDATE mtl_material_transactions_temp
2747: SET primary_quantity = primary_quantity - l_sku_pri_decr
2748: WHERE transaction_temp_id = t_temp_id(i);
2749:
2750: UPDATE mtl_txn_request_lines

Line 3063: UPDATE mtl_material_transactions_temp

3059: || ' lot ' || p_lot_number, 4);
3060: END IF;
3061: END IF;
3062:
3063: UPDATE mtl_material_transactions_temp
3064: SET primary_quantity = primary_quantity + l_sku_pri_incr
3065: WHERE transaction_temp_id = t_temp_id(j);
3066:
3067: UPDATE mtl_txn_request_lines

Line 3327: FROM mtl_material_transactions_temp

3323: l_progress VARCHAR2(10) := '0';
3324:
3325: CURSOR mmtt_cur IS
3326: SELECT rowid, transaction_temp_id, transaction_quantity, transaction_uom
3327: FROM mtl_material_transactions_temp
3328: WHERE organization_id = p_organization_id
3329: AND inventory_item_id = p_inventory_item_id
3330: AND NVL(revision, '@') = NVL(p_revision, '@')
3331: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 3413: UPDATE mtl_material_transactions_temp

3409: IF ( p_lot_number IS NULL ) THEN
3410: l_progress := '400';
3411: IF ( p_secondary_quantity IS NULL ) THEN
3412: -- Caller wants to null out all secondary_quantity for this item
3413: UPDATE mtl_material_transactions_temp
3414: SET secondary_transaction_quantity = NULL,
3415: secondary_uom_code = NULL
3416: WHERE organization_id = p_organization_id
3417: AND inventory_item_id = p_inventory_item_id

Line 3452: UPDATE mtl_material_transactions_temp

3448: ELSE
3449: l_line_quantity := mmtt_rec.transaction_quantity;
3450: END IF;
3451:
3452: UPDATE mtl_material_transactions_temp
3453: SET secondary_transaction_quantity = round(p_secondary_quantity*(l_line_quantity/p_quantity), g_precision),
3454: secondary_uom_code = p_secondary_uom_code
3455: WHERE rowid = mmtt_rec.rowid;
3456:

Line 3472: FROM mtl_material_transactions_temp mmtt

3468: secondary_unit_of_measure = NULL
3469: WHERE lot_number = p_lot_number
3470: AND transaction_temp_id IN (
3471: SELECT transaction_temp_id
3472: FROM mtl_material_transactions_temp mmtt
3473: WHERE organization_id = p_organization_id
3474: AND inventory_item_id = p_inventory_item_id
3475: AND NVL(revision, '@') = NVL(p_revision, '@')
3476: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 3608: FROM mtl_material_transactions_temp

3604: ORDER BY msi.primary_uom_code, msi.secondary_uom_code;
3605:
3606: CURSOR mmtt_item_cur IS
3607: SELECT distinct inventory_item_id, organization_id
3608: FROM mtl_material_transactions_temp
3609: WHERE organization_id = p_organization_id
3610: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3611: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3612: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )

Line 3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3803: BEGIN
3804: SELECT 1 INTO l_temp FROM DUAL
3805: WHERE EXISTS (
3806: SELECT 1
3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3808: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
3809: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
3810: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3811: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

Line 4069: mtl_material_transactions_temp mmtt,

4065: SELECT UNIQUE wlpn.license_plate_number,
4066: mmtt.transfer_lpn_id,
4067: wlpn.lpn_context
4068: FROM wms_license_plate_numbers wlpn,
4069: mtl_material_transactions_temp mmtt,
4070: mtl_system_items_b msi
4071: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4072: AND mmtt.organization_id = msi.organization_id
4073: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4087: mtl_material_transactions_temp mmtt,

4083: SELECT UNIQUE wlpn.license_plate_number,
4084: mmtt.transfer_lpn_id,
4085: wlpn.lpn_context
4086: FROM wms_license_plate_numbers wlpn,
4087: mtl_material_transactions_temp mmtt,
4088: mtl_system_items_b msi
4089: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4090: AND mmtt.organization_id = msi.organization_id
4091: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4107: mtl_material_transactions_temp mmtt,

4103: SELECT UNIQUE wlpn.license_plate_number,
4104: mmtt.transfer_lpn_id,
4105: wlpn.lpn_context
4106: FROM wms_license_plate_numbers wlpn,
4107: mtl_material_transactions_temp mmtt,
4108: mtl_material_transactions_temp mmtt2,
4109: mtl_system_items_b msi
4110: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4111: AND mmtt2.organization_id = msi.organization_id

Line 4108: mtl_material_transactions_temp mmtt2,

4104: mmtt.transfer_lpn_id,
4105: wlpn.lpn_context
4106: FROM wms_license_plate_numbers wlpn,
4107: mtl_material_transactions_temp mmtt,
4108: mtl_material_transactions_temp mmtt2,
4109: mtl_system_items_b msi
4110: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4111: AND mmtt2.organization_id = msi.organization_id
4112: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4152: mtl_material_transactions_temp mmtt,

4148: SELECT UNIQUE wlpn.license_plate_number,
4149: mmtt.transfer_lpn_id outer_lpn,
4150: wlpn.lpn_context
4151: FROM wms_license_plate_numbers wlpn,
4152: mtl_material_transactions_temp mmtt,
4153: mtl_system_items_b msi
4154: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4155: AND mmtt.organization_id = msi.organization_id
4156: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4169: FROM mtl_material_transactions_temp mmtt,

4165: AND NVL(wlpn.catch_weight_flag,'N') = 'N'
4166: UNION
4167: SELECT UNIQUE wlpn.license_plate_number,
4168: mmtt.transfer_lpn_id, wlpn.lpn_context
4169: FROM mtl_material_transactions_temp mmtt,
4170: mtl_system_items_b msi,
4171: wms_license_plate_numbers wlpn
4172: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4173: AND mmtt.organization_id = msi.organization_id

Line 4192: mtl_material_transactions_temp mmtt,

4188: SELECT UNIQUE wlpn.license_plate_number,
4189: mmtt.transfer_lpn_id,
4190: wlpn.lpn_context
4191: FROM wms_license_plate_numbers wlpn,
4192: mtl_material_transactions_temp mmtt,
4193: mtl_material_transactions_temp mmtt2,
4194: mtl_system_items_b msi
4195: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4196: AND mmtt2.organization_id = msi.organization_id

Line 4193: mtl_material_transactions_temp mmtt2,

4189: mmtt.transfer_lpn_id,
4190: wlpn.lpn_context
4191: FROM wms_license_plate_numbers wlpn,
4192: mtl_material_transactions_temp mmtt,
4193: mtl_material_transactions_temp mmtt2,
4194: mtl_system_items_b msi
4195: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4196: AND mmtt2.organization_id = msi.organization_id
4197: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4260: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,

4256: , p_entry_type
4257: ) = 'Y'
4258: UNION
4259: SELECT DISTINCT license_plate_number, content_lpn_id
4260: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,
4261: wms_license_plate_numbers wlpn
4262: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4263: AND mmtt.organization_id = p_org_id
4264: AND mmtt.parent_line_id IS NULL

Line 4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

4271: ELSE
4272: IF (p_lpn_context = 8) THEN --Packing
4273: OPEN x_lpn_lov FOR
4274: SELECT distinct wlpn.license_plate_number, mmtt.content_lpn_id
4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
4276: ,wms_license_plate_numbers wlpn
4277: ,mtl_transaction_lots_temp mtlt
4278: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4279: AND mmtt.organization_id = p_org_id

Line 4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

4484: , NVL(msi.secondary_default_ind,'')
4485: , NVL(msi.tracking_quantity_ind,'P')
4486: , NVL(msi.dual_uom_deviation_high,0)
4487: , NVL(msi.dual_uom_deviation_low,0)
4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
4489: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4490: AND mmtt.organization_id = p_org_id
4491: AND mmtt.organization_id = msi.organization_id
4492: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 4548: mtl_material_transactions_temp mmtt,

4544: , NVL(msi.tracking_quantity_ind,'P')
4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi
4550: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4551: AND mmtt.organization_id = p_org_id
4552: AND mmtt.organization_id = msi.organization_id